Data Consolidation allows you to gather together your data from separate worksheets into a master worksheet. In other words, the Data Consolidation function takes data from a series of worksheets or workbooks and summaries it into a single worksheet that we can update easily.
To Use Consolidate function, do the following:-
1. Open all workbooks or sheets we want to consolidate. Ensure the data is organized in the same way
2. Open a blank workbook. On the Data tab, in the Data Tools group, click Consolidate
3. Choose the Sum function to sum the data.
4. Click in the Reference box, select the range eg A1:E4 in the first workbook, and click Add.
5. Repeat step 4 for the next workbooks.
6. Check Top row, Left column and Create links to source data.
7. Click OK. This adds the consolidated data to the blank spreadsheet or workbook.
0 Comments:
Post a Comment