Linking Data
A link can be as simple as a reference to a cell on another worksheet, or it can be part of a formula. You can link cells between sheets within one workbook or between different workbooks. Cell data to be linked is called the source data. The cell or range linked to the source data is called the destination cell or destination range. If you no longer want linked data to be updated, you can easily break a link. Create links instead of making multiple identical entries; it saves time and ensures your entries are correct.
Create a Link Between Worksheets or Workbooks
Select the cell or range that contains the source data.
Click the ...
Get Excel® 2013 On Demand now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
