Copy/paste range with date lookup

[plague5050]

I am trying to create a Macro to paste a range of cells from Sheet1 to Sheet2.

The tricky part is that before it pastes i need it to find the correct cell to paste the range into. In this case it is a date formatted in mmm-yy

After all the searching i did, i could only find static copy paste or ActiveCell.Offset type things. I need the macro to be able to mach up the date, then shift down one cell, then paste the range.

I have provided a test.xlsx to help you guys understand what im trying to do.

Thanks in advance

[venkat1926]

try this macro, next change C1 and again try

Please Login or Register  to view this content.