Chapter 24. Linking and Consolidating Worksheets

You can link the information stored in one workbook to another workbook to ensure that you have up-to-date information at all times. Suppose your company keeps daily sales records in a workbook that is updated each day by another employee. Your job is to summarize the daily sales information so you can then produce a variety of charts that show sales trends over time. You need the daily sales information to do your job.

You could open the other employee's workbook and copy the information into your own workbook. However, if you create a workbook that contains link formulas — also called external reference formulas — to the daily sales workbook, your workbook will always contain the latest data.

Get Master VISUALLY® Excel® 2010 now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.