VB Code to Match the text and copy to another sheet

[rizmomin]

Hello:

Please refer to attached file.
First, please refer to Sheet1.
I will have Store Name in Cell S1 and date in Cell T1.
(Remember that Store name and Date is variable and it is coming from other source.
So i need VB Code (Not Formula) to match the Store Name from Sheet1 and match in Sheet2, Cell F4:F11. Once it finds the match, copy the date from sheet1 cell T1 to corresponding cell in sheet2 as shown.


Let me know if you have any questions.
Thanks.

[rizmomin]

Hello:

Please refer to attached file.
I have come up so that this is come easy.
Now I will have Sheet1 Cell U1 will have the actual cell location for Sheet2 paste.
So now for example:
Would need a code to copy the Range("S1:T1") from sheet1 and paste it at Sheet2 @ cell F8 (This is in Sheet1 Range("U1:U1").

I hope this is clear.


Let me know if you have any questions.
Thanks.
Riz

[rizmomin]

Hello Guys:
I have resolved the problem my self with the below code.
Thanks a lot for looking.

Please Login or Register  to view this content.

Riz