Referencing worksheets
 

I am trying to reference cells from sheet to sheet.
Ex: Sheet 1, A3 = 100
How do I reference Sheet 1 A3 in Sheet 2 C5 or Sheet 3 B4?
Thanks for the help

Referencing worksheets
 

If i,m understanding correctly:-

Select your cell in sheet 3 and type =

use the sheet tabs to navigate to another sheet and select the cell you want

Click the green tick by the formula bar and it should look like this:-

=Sheet1!A1

Mike

"jbaldwin" wrote:

I am trying to reference cells from sheet to sheet.
Ex: Sheet 1, A3 = 100
How do I reference Sheet 1 A3 in Sheet 2 C5 or Sheet 3 B4?
Thanks for the help

Referencing worksheets
 

Wed, 4 Jul 2007 05:46:04 -0700 from Mike H
:

"jbaldwin" wrote:
How do I reference Sheet 1 A3 in Sheet 2 C5 or Sheet 3 B4?

Select your cell in sheet 3 and type =

use the sheet tabs to navigate to another sheet and select the cell you want

Click the green tick by the formula bar and it should look like this:-

=Sheet1!A1

That will work, or the OP can also type that expression directly as a
formula.

If the worksheet name contains blanks or certain other special
characters, it must be enclosed in single quotes:
='Sheet 1'!A3
--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/