Chapter 28: Linking and Consolidating Worksheets
28
FIGURE 28.7
Three worksheets to be consolidated- Enter the reference for the first worksheet to consolidate. If the workbook is
open, you can point to the reference; if it isn’t open, click the Browse button to
locate the file on disk. The reference must include a range. You can use a range that
includes complete columns, such as A:K. This range is larger than the actual range
to consolidate, but using this range ensures that the consolidation will still work if
new rows and columns are added to the source file. - When the reference in the Reference box is correct, click Add to add it to the
All References list. - Enter the reference for the second worksheet. You can point to the range in the
Region2 workbook, or you can simply edit the existing reference by changing
Region1 to Region2 and then clicking Add. This reference is added to the All
References list. - Enter the reference for the third worksheet. Again, you can edit the existing ref-
erence by changing Region2 to Region3 and then clicking Add. This final refer-
ence is added to the All References list. - Because the worksheets aren’t laid out in the same way, select the Left Column
and the Top Row check boxes to force Excel to match the data by using the
labels.