Referencing worksheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Wed, 4 Jul 2007 05:46:04 -0700 from Mike H
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
Click to expand...

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
 
Back
Top