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
Hi,
I recorded a macro and then put in a match function to tell which row the copy should be on. See the attached: Hope that is what you wanted. Look at the macro and start learning how to do this stuff.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Please Login or Register to view this content.
If solved remember to mark Thread as solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks