Copy and paste specific range to date specific range in alternate sheet

**alanalmarza** · 01-21-2013, 02:03 AM

Hi There,

Was wondering how i would go about getting code to use sheet1; to search A1 [=today()] to copy range H3:H7 and paste that information to a column seaching row#10:10 for the today range, when the date is located, to paste that information to ?11:?15?

**AlphaFrog** · 01-21-2013, 02:41 AM

Please Login or Register  to view this content.

**alanalmarza** · 01-21-2013, 08:29 AM

Still a bit lost on this one. i have attached an example of what i am trying to do. On Sheet1 the range H3:H6 needs to be copied and pasted to the exact match of cell A1 which is todays date: this would run daily at around 4pm, into sheet2 under that same date found on sheet1. its just a copy and special number paste function which will be date specific.

any help?

THANKS!