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

[Spaceballs_the_fanboy]

Hi. 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 that date 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) amd paste it into the same row Column B. I would like the same for another cell into the same row in Column C.

Your help is much appreciated.

 

[Fluff]

Cross posted https://www.ozgrid.com/forum/forum/...-ws1-and-find-same-date-in-ws2-copy-and-paste

Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Spaceballs_the_fanboy]

Cross posted https://www.ozgrid.com/forum/forum/...-ws1-and-find-same-date-in-ws2-copy-and-paste

Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

My apologies. How may I remove my post from here?

 

[Fluff]

You do not need to remove it.
All we ask, is that you let us know by supplying links to any other sites where you have asked the same question.

 

[Spaceballs_the_fanboy]

Hi.
I have also posted the question here:
https://www.ozgrid.com/forum/forum/...-ws1-and-find-same-date-in-ws2-copy-and-paste

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 that date 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) amd paste it into the same row Column B. I would like the same for another cell into the same row in Column C.

Your help is much appreciated.