Results 1 to 10 of 17

Thread: Copy and paste of data if matches Conditional calculation and pasting of the data

Threaded View

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

    Conditional calculation and pasting of the data

    calculate the total value of column Q of ActualFile.xlsx and if it is Greater than S10 of ActualFile.xlsx then do nothing & if it is lower than S10 of ActualFile.xlsx then divide S10 of ActualFile.xlsx with the total value of Column Q of ActualFile.xlsx & match column B of actual file.xlsx with column A of 2.xlsx and if it matches then increased the number that much time of 2.xlsx (Take the roundfigure of the number instead of 79.86 take 79 to increase that much time, see the cell highlighted in green colour ) & copy S10 value and paste it to S9 & S8
    I have tried to explain everything in sheet2 of both the files but the actual file is sheet1 of both file
    vba will be placed in macro.xlsm
    So plz have a look and help me in solving this problem Sir
    there can be highlighted colour in sheet1 of 2.xlsx but ignore it (dont do anything with that, dont remove the highlighted colour )
    Attached Files Attached Files

Similar Threads

  1. copy data and paste it in another sheet
    By newbie2 in forum Excel Help
    Replies: 1
    Last Post: 07-15-2015, 06:21 PM
  2. copy data and paste it in another sheet
    By newbie2 in forum Excel Help
    Replies: 1
    Last Post: 07-15-2015, 01:38 PM
  3. Replies: 0
    Last Post: 04-20-2013, 10:07 AM

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
  •