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!