Consolidating data excel

(13 printed pages)Ron de Bruin, Microsoft Office Excel MVPFrank Rice, Microsoft Corporation August 2008Applies to: Microsoft Office Excel 2007, Microsoft Office Excel 2003, Microsoft Excel 2002, Microsoft Excel 2000Contents or consolidate the data in each worksheet into a summary worksheet.

consolidating data excel-2consolidating data excel-7consolidating data excel-38

This ensures that the data is always up-to-date after you run the code.

Next, the code loops through the range on each worksheet and copies the values and formatting to the summary worksheet.

Summary: Microsoft Office Excel MVP Ron de Bruin provides a number of samples to merge data from multiple worksheets into one summary worksheet.

After you have all the data on one worksheet, you can do things such as build a Pivot Table report based on your specific criteria or use the filter options in Excel 2007 to get the results you want.

Data consolidation refers to the collection and integration of data from multiple sources into a single destination.

During this process, different data sources are put together, or consolidated, into a single data store.

When you consolidate data, you are assembling data so that you can more easily update and aggregate as needed.

For example, if you have an expense worksheet for each of your regional offices, you might use consolidation to roll these figures into a master corporate expense worksheet.

To do this select an empty sheet in the workbook - add a new one if necessary - and click in it.

Choose Data Consolidate to view the Consolidate dialog.

Microsoft Excel features a data-consolidation function that allows several tables to be consolidated into a single summary report.

Tags: , ,