Page 286 - Excel 2013 All-in-One For Dummies
P. 286
268 Consolidating Worksheets
Figure 4-15:
Consolidated worksheet with links
to the sales data from three years.
This formula links the value in cell B4 in the Sales 2010 sheet of the CG Media - 2010 Sales.xlsx workbook. If you change this value in that worksheet, the new value is automatically updated in cell B4 in the CG Media Consolidated Sales 2010-12.xlsx workbook, which, in turn, changes the subtotal for the January Rock music CD sales in cell B6.
