[ LiB ] |
Sometimes you need to refer to information stored in another worksheet. For example, if you have a workbook with sheets for each month's sales information, along with a worksheet that totals the monthly worksheets, you can create a reference in the Totals worksheet that instructs Excel to reference the data in the various monthly worksheets. When you create a reference to a different sheet, Excel will use the name of the sheet first, then the cell location.
Excel will return you to the original worksheet with the value displayed.
If the value in the originating cell changes, the value in the cross reference cell will also change.
[ LiB ] |