13.3.4.Consolidate Data from Other Worksheets or Workbooks |
|
Open the source workbook.
Open the workbook that will contain the consolidated data.
|
|
 |
Select the destination range.
Click the Data tab. Then click the Consolidate button.
|
|
 |
Click the Function list arrow, and then select the function for consolidating data.
|
|
 |
Type the location of the data.
|
|
 |
Or click the Expand Dialog button.
|
|
 |
Click Add to add the reference to the list of consolidated ranges.
|
|
 |
Select the Create links to source data check box.
|
|
 |
|
 |