Copy paste between 2 worksheets VBA

Hello All !

I have two sheets. In S1(Sheet1), Cells B4 to AW4 are dates (first day of the month in format mmm-yy), This is a ROW(Row4 in excel). Cells A5 to A140 is exactly the same stuff but this is a column(Column A in excel). In S2, i have 2 columns. Column A is with dates in the same format as in S1, and column B in S2 is some random data.

I want help in a macro that checks the value(a date) of the first cell in S2, (i.e cell A1), copies the entire column B , goes to S1 finds the "INTERSECTING CELL" and pastes the data.

What is the intersecting cell ? It is the cell in S1 with same date in row 4 as in column A. These two dates and the date of Cell A1 in S2 will be same.


My Cross Posts in other forums:

Cross post http://www.excelkey.com/forum/viewto...8&p=5119#p5119
http://www.mrexcel.com/forum/showthr...95#post3177095