working between work sheets .pls support tnks

  • Thread starter Thread starter Edward
  • Start date Start date
E

Edward

Hi,
I am working on an excel worksheet and have a number of
sum totals. How can these totals be read in a second or
third separate sheet of the same file for other
appilications??
 
Say one total is in sheet1, cell J10. Then in the second sheet,
enter:

A1: =Sheet1!J10

You can make this easier by typing "=" in the cell you want to hold
the reference, then navigate to the first sheet and click in the
cell to be referenced - XL will add the sheet name.
 
Back
Top