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.
(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.
It also deletes the summary worksheet RDBMerge Sheet, if it exists, and then adds a new sheet to the workbook.
This code copies all of the data from each worksheet except that the starting row in the source worksheets is set to the second row.
The different procedures demonstrate techniques for copying varying size ranges as well as placing the data at specific locations in the summary sheet.
You can download a workbook that contains the code in this article at Ron de Bruin's Web site.
This ensures that the data is always up-to-date after you run the code.