Microsoft Office Tutorials and References
In Depth Information
Consolidating multiple sets of data
SET UP You need the Consolidate, JanuaryCalls, and FebruaryCalls workbooks located
in the Chapter07 practice file folder to complete this exercise. Open the workbooks, and
then follow the steps.
In the Consolidate workbook, on the Data tab, in the Data Tools group, click
Consolidate to open the Consolidate dialog box.
Click the Collapse Dialog button at the right edge of the Reference field to contract
the Consolidate dialog box.
On the View tab, in the Window group, click Switch Windows and then, in the list,
click JanuaryCalls to display the JanuaryCalls workbook.
Select the cell range C5:O13 , and then click the Expand Dialog button to restore the
Consolidate dialog box to its full size.
Click Add to add the selected range to the All references box.