skip to content »

Consolidating two excel files

The different procedures demonstrate techniques for pasting the data by row or by column.

consolidating two excel files-33

Consolidate feature in Excel 2010, lets you to pull-each record from the worksheet in to one master worksheet, which adds-up all data from spreadsheets.Common methods to consolidate in Excel include consolidating by position, by category, by formula or by using Excel’s Pivot Table feature.Scroll past the jump to learn how to consolidate in Excel so that your information appears in a master worksheet as a reference whenever you need to generate reports.This procedure fills an array with the path and name of each workbook in a folder.It then loops through the array and for each source file, checks the source and target ranges to see if there are more columns used in the source range than are available in the target range.You can use Excel's Consolidate feature to consolidate your worksheets (located in one workbook or multiple workbooks) into one worksheet. If you check Create links to source data, Excel creates a link to your source data (your consolidated data will be updated if your source data changes) and creates an outline.

Below you can find the workbooks of three districts.

Excel's Consolidate feature's claim to fame is merging and summarizing values from multiple workbooks.

It's a great tool for combining data when several users work with different instances of the same file.

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.

And finally, you will see a utility that pulls all of these techniques together and more in one location.