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

Chapter 6. Function Fundamentals > Referencing Values in Other Worksheets and W...

Referencing Values in Other Worksheets and Workbooks

You can write formulas that calculate values in other worksheets and other workbooks, which is a common way to compile and summarize data from several different sources. When you write formulas that reference other worksheets and workbooks, you create links to those other worksheets and workbooks.

Referencing Other Worksheets

Suppose you have a workbook that contains separate worksheets for each division in your company. You can combine data from each division’s worksheet in a Summary sheet in that same workbook to compile and analyze data for the entire company. Formulas on the Summary sheet will need to reference data on the individual division sheets (these are called external references). You can create external references by switching to the other worksheet and clicking and dragging the cells you want to reference, just as in a same-worksheet reference; the only difference is that the cells are located on a different worksheet.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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