Jane has attended:
Excel Advanced course
How do I merge spreadsheets
I have two or more spreadsheets containing different pieces of information for the same people. I often need to combine the spreadsheets into one to analyse the information. Sometimes I may need to 'split' a spreadsheet into two or more separate ones.
Any help would be hugely appreciated!
Thanks
RE: how do I merge spreadsheets
Hi Jane
Thank you for your question.
When you say that the spreadsheets contain different pieces of information for the same people, do each of the spreadsheets have the same column and row headings or not?
thanks
Amanda
RE: how do I merge spreadsheets
No - they contain information about pupils - one spreadsheet may contain previous exam results, another may contain information about behaviour, homework, etc. The only thing that is the same on both is the names!
RE: how do I merge spreadsheets
Hi Jane
If the spreadsheets are saved in two separate files, then you can import data from one file into another by going through Data - Import external data - Import data. You will be able to select the file and sheet that you wish to import data from; tell Excel which cell you want the imported data to start from, and it will copy the data across to that location.
I don't know if this helps you - please let me know if not.
Amanda
RE: how do I merge spreadsheets
it's a start! I'm now left with the problem that, (eg) on one spreadsheet I may be a name missing (or have an additional name) - when I then import data from another worksheet, it's really difficult to combine the information when the names don't entirely match up.
RE: how do I merge spreadsheets
Hi Jane
Unfortunately I don't think there's a quick fix for these problems - you will need to deal with them by rearranging the information once imported. The only other thing I can suggest to try and encourage people to enter all the information you need into the spreadsheets you are importing data from is to set up data validation in those sheets to try and guide people to enter information fully and accurately into these sheets.
Amanda
