Reference a cell on another worksheet in the same spreadsheet file

D

Dave

I have Excel 2000.

I have a large spreadsheet with multiple worksheets in it. I have the
need to write a formula in a cell in one of the worksheets that
references the value of a cell in a different worksheet (all in the
same spreadsheet file).

I have checked my manual & the help file, but I still could use some
assistance.

Thanks in advance for the assistance.
 
B

Bob Phillips

='sheet name'!A1

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
J

Jason Morin

1. Click on the cell where you want to return the value from another cell.
2. Press the "=" key.
3. Click on the worksheet that contains the cell with value you wish to
return.
4. Now click on that cell.
5. Press <Enter>.

HTH
Jason
Atlanta, GA
 
D

Dave Peterson

And if the "sending" cell is empty, you may want:

=if('sheet 1'!a1="","",'sheet 1'a1)

='sheet 1'!a1

will show a 0 if that sending cell is empty.
 
Top