Page 213 - Excel Timesaving Techniques for Dummies

41_574272 ch36.qxd 10/1/04 10:54 PM Page 198
198
Technique 36: Consolidating Data from Different Worksheets
This formula links the value in cell B4 in the Sales 01
sheet of the CG Media - 2001 Sales.xls workbook.
If you change this value in that worksheet, the new
value is updated automatically in cell B4 in the CG
Media - Consolidated Sales 01-04 workbook,
which, in turn, changes the subtotal for the January
rock music CD sales in its cell B7.

• Figure 36-4: Consolidated worksheet with links to sales
data from the last four years.