Consolidating multiple excel workbooks

Tip: If you frequently consolidate data, it might help to base your worksheets on a worksheet template that uses a consistent layout.

To learn more about Templates, see: Create a template.

Note: if you don't check Top row and Left column, Excel sums all cells that have the same position.

Click in the Reference box, select the range A1: E4 in the district1 workbook, and click Add. Repeat step 4 for the district2 and district3 workbook. Check Top row, Left column and Create links to source data.

Because our worksheets are not identical, we want Excel to sum cells that have the same labels.

There are two ways to consolidate data: by Category or by Position.Additionally, you will see how to retrieve data by using a filter.And finally, you will see a utility that pulls all of these techniques together and more in one location.The samples described in this article add a worksheet to the active workbook and then copy a range of cells from every worksheet to the summary worksheet.The different procedures demonstrate techniques for copying varying size ranges as well as placing the data at specific locations in the summary sheet.

Leave a Reply