Consolidating data in excel worksheets
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 merge the data in each workbook into a master workbook.
The examples described in this article add the data from multiple workbooks to a summary workbook.
This procedure uses the first worksheet (index 1) of each workbook.
To start with a different worksheet to use a specific worksheet, just change the index number or change the index to the name of the worksheet.
The different procedures demonstrate techniques for pasting the data by row or by column.
Additionally, you will see how to retrieve data by using a filter.
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 worksheets you consolidate can be in the same workbook as the master worksheet or in other workbooks.
Next the procedure copies the path and name of the source workbook into column A.