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.