Results 1 to 10 of 41

Thread: copy,paste,calculate Cell value based on calculations & comparisonsother cells same row. Decimal places

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Senior Member
    Join Date
    Jul 2019
    Posts
    382
    Rep Power
    0

    copy,paste,calculate Cell value based on calculations & comparisonsother cells same row. Decimal places



    “Moderator” Notice
    September 2020
    Given up with this “OP” , Avinash around September 2020. https://excelfox.com/forum/showthrea...ll=1#post14972
    https://excelfox.com/forum/showthrea...ll=1#post14972

    I am no longer monitoring what its doings. It had curiosity appeal for a while, but even that has worn off me now!
    It’s getting worse by the Day. Its still doing whatever it is that it is doing and getting Replies and answers at excelforum.com and likely a few places I don’t know about.










    vba code will be placed in a seperate file macro.xlsm
    i have one more file 1.xls (all files are located in a different path)
    i have attached a sample pic of 1.xls & result pic too
    check if Column H is greater or lower than column D
    if column H is greater than column D then calculate 1% of column H and paste it to column J and then subtract Column H & column J and paste the result to column K
    Or
    if column H is lower than column D then calculate 1% of column H and paste it to column J and then add Column H & column J and paste the result to column K
    Plz help me in solving this problem sir








    Almost the same as from MoldyBread at excelforum
    https://www.excelforum.com/excel-pro...ml#post5338184









    Some more recent cross posted duplicsate on another one of Avinashes infinite cycles of starting again
    https://eileenslounge.com/viewtopic.php?f=30&t=34932
    https://chandoo.org/forum/threads/pu...9/#post-266257 ( Leonardo1234 starting again )
    Attached Images Attached Images
    Last edited by DocAElstein; 09-26-2020 at 07:22 PM.

Similar Threads

  1. Replies: 26
    Last Post: 09-26-2020, 05:56 PM
  2. Replies: 6
    Last Post: 08-28-2019, 09:42 AM
  3. copy data and paste it in another sheet
    By newbie2 in forum Excel Help
    Replies: 1
    Last Post: 07-15-2015, 01:38 PM
  4. Trapping Copy To Range Before Copy/Cut Paste
    By Rasm in forum Excel Help
    Replies: 4
    Last Post: 04-07-2011, 07:48 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •