Claire has attended:
Excel Advanced course
Merging spreadsheets
I have a spreadsheet that is updated by individual salesmen and needs to be merged onto one spreadsheet at the end of the week. Is there a quick way of doing this with the updates they send through?
RE: Merging spreadsheets
Hi Claire
Thank you for your question, and welcome to the forum.
A suggestion would be to set up a master spreadsheet which collates information from all the individual spreadsheets, via links.
The important thing here would be to have the master spreadsheet and most recent copy of each salesperson's spreadsheet saved in the same folder.
If you are being emailed the spreadsheets, then save each person's spreadsheet over their last copy (therefore keeping the same filename), then you can open the master spreadsheet and if the links are set up correctly the information in your master spreadsheet should update.
There may be a trust/security settings bar that appears near the top of the screen where you need to click Options then Enable to get the data to update.
Otherwise I'm sure there is something really fancy you could do using VBA coding to automate this process for you. We do run a 2 day Excel VBA course if you think this would be helpful.
Amanda
