Lookup date in ws1 and find same date in ws2 copy and paste

  • Hi. I have also posted this question here: https://www.mrexcel.com/forum/…-date-ws2-copy-paste.html
    I have an worksheet that is updated every week.
    However, I want to copy and paste the values from 2 different cells into another worksheet.
    Worksheet 1 will have a date entered in cell H1.
    I want to find the date from Sheet1 H1 in Column A on worksheet 2, and then I want it to copy the value (as the cell contains a formula and I don't want the formula to copy) and paste it into the same row Column B. I would like to do the same for another cell into the same row in Column C.

    Your help is much appreciated.

  • MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question


    There are 10 types of people in the world. Those that understand Binary and those that dont. :P

    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25... ;)


  • try this

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!