VBA Scrip to Identify a cell in Sheet 1 and paste data under the identified cell.

[bala4370]

Hi,

I am looking for a simple macro for

1. Read the date in Cell K2 (Sheet 2) and find the same date in Row 1 in Sheet 1.
2. Once the date is identified, copy data from Cell C2:C230 and paste it under the identified cell.

For Example : If the Date is identified in cell H1 of Sheet 1, the data needs to be pasted in cells H3:H231

Regards,
Santhosh

 

[oldbrewer]

write your macro in sheet 2, set mydate = cells(2,11)
copy the cells using range("c2:c230").select and selection.copy
then sheets(1).select
you are now in sheet 1 so run along row 1 until date matches
drop down one cell and paste

or do you not use macros at all ?