For example, you can use the Consolidate command to total all budget spreadsheets prepared by each department in the company or to create summary totals for income statements for a period of several years.If you used a template to create each worksheet you’re consolidating, or an identical layout, Excel can quickly consolidate the values by virtue of their common position in their respective worksheets.This ensures that the data is always up-to-date after you run the code.
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 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.
To begin consolidating the sheets in the same workbook, you select a new worksheet to hold the consolidated data.
(If need be, insert a new sheet in the workbook by clicking the Insert Worksheet button.) To begin consolidating sheets in different workbooks, open a new workbook.