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
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