Excel consolidating

Rated 3.86/5 based on 970 customer reviews

When the original spreadsheet is updated, the merged spreadsheet is automatically updated, similar to an Excel Pivot Table.Randall Blackburn has worked for several Fortune 1000 companies as a technical writer over the past seven years.

The spreadsheet can be in the same workbook or in a different workbook file.The Consolidate Data dialog box includes the “Create Links to Source Data” option.When this option is selected, the merged data includes links to the data in the original spreadsheet.Whatever the reason, you can merge data from one Excel spreadsheet to another using Excel's Consolidate Data wizard.If you have only a few spreadsheets to combine, and the column headers and orders are identical, you can also simply copy and paste the data into a master sheet, though the sheet won't automatically update if the others change.

Leave a Reply