Reference a cell on another worksheet in the same spreadsheet file
 

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.

='sheet name'!A1

--

HTH

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


"Dave" wrote in message
...
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.

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

"Dave" wrote:

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.

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.

Dave wrote:

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.

--

Dave Peterson