Microsoft® Office Excel 2003 Inside Out

Consolidating Worksheets

You can use the Consolidate dialog box (choose Data, Consolidate), shown in Figure 9-34, to combine the values from a set of worksheets in the same workbook or from different workbooks. The Consolidate command allows you to assemble information from as many as 255 supporting worksheets into a single master worksheet.

Figure 9-34. The default function in the Consolidate dialog box is Sum.

For example, if you have data for each month in separate worksheets or financial data for several divisions in separate workbooks, you can use the Consolidate command to create a master worksheet that comprises the totals for the corresponding ...