Microsoft® Excel® 2010 Inside Out

Consolidating Worksheets

You can use the Consolidate button on the Data tab to combine the values from a set of worksheets in the same workbook or from different workbooks. The Consolidate command lets you assemble information from as many as 255 supporting worksheets in a single master worksheet and displays the Consolidate dialog box shown in Figure 8-71.

Figure 8-71. 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, ...