• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Hour 14. Working Smarter > Creating Links Between Worksheets and Workbooks

Creating Links Between Worksheets and Workbooks

Linking is the process of dynamically updating data in a worksheet from data in another source worksheet or workbook. When data is linked, the linked data reflects any changes you make to the original data.

Linking is accomplished through special formulas that contain references known as external references. An external reference can refer to a cell in a different worksheet in the same workbook or to a cell in any other worksheet in any other workbook.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint