98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » Merging spreadsheets
Merging spreadsheets
Resolved · Low Priority · Version 2007
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
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Outlining - Grouping rows or columnsHighlight want you want to group and press ALT + SHIFT + left cursor arrow |