copy and paste based on date criteria

thedeadzeds

New member
Joined
Oct 25, 2011
Messages
37
Reaction score
0
Points
0
Excel Version(s)
2016
Hi Guys,

Is there a way to copy and paste data from one sheet to another but have the data copy to a relevant cell based on the date in the first sheet.

I have attached a copy of a spreadsheet. Basically, each day the summary tab is updated and then the archive tab is updated manually. I want to be able to click a macro and have the data copied over automatically.

Hope this makes sense.

Thanks
Craig
 

Attachments

  • Data and Archive.xlsx
    13.9 KB · Views: 8
Top