CHAPTER 28
Linking and Consolidating Worksheets
In this chapter, we discuss two procedures for using data from other workbooks or worksheets: linking and consolidating. Linking is the process of using references to cells in external workbooks to get data into your worksheet. Consolidating involves combining or summarizing information from two or more worksheets (which can be in multiple workbooks).
Linking Workbooks
Excel allows you to create formulas that contain references to other workbook files. With such formulas, the workbooks are linked in such a way that one depends on the other. The workbook that contains the external reference formulas is the dependent workbook (because it contains formulas that depend on another workbook). The workbook that contains the information used in the external reference formula is the source workbook (because it's the source of the information...
