RE: How do I consolidate data
Hi Carole
Thank you for your question.
The idea behind consolidating data is to make a summary spreadsheet from data on seperate spreadsheets. It is important that each spreadsheet has the same column headings and row headings.
1. Select a cell where you want your consolidated data to begin appearing from (i.e. the top-left corner of where the consolidated data will go).
2. Go to Data-Consolidate.
3. Choose which function you want to use for the consolidation.
4. From the Refence area, select the first range of cells to be included in the consolidated data, including the row and column headings.
5. Click Add.
6. Repeat steps 4 and 5 until you have selected and added all the data ranges to be consolidated.
7. Tick the 'Top row' and 'Left column' boxes, and tick 'Create links to source data' if you wish the consolidated data to be linked to the data from each sheet.
8. Click OK.
I hope this helps.
Amanda