Creating a Reference to Another Worksheet

[ 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.


graphic/08fig12.gif



graphic/08fig13.gif


Excel will return you to the original worksheet with the value displayed.


graphic/08fig14.gif


If the value in the originating cell changes, the value in the cross reference cell will also change.

[ LiB ]


Microsoft Office Excel 2003 Fast & Easy
Windows XP Registry: A Complete Guide to Customizing and Optimizing Windows XP (Information Technologies Master Series)
ISBN: N/A
EAN: 2147483647
Year: 2002
Pages: 157
Authors: Olga Kokoreva

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net