Excel Cell Value Problem

[eithne]

In Excel I have for example sheet 1 and sheet 2.
I need to transfer a value from sheet 1 to sheet 2 but sheet 1's nam
always changes but sheet 2's name stays the same.
Do you know how i could write a statement in sheet 1 to say that th
value in cell F45 for example should be put into sheet 2 cell G56 fo
example.

I hope this makes sense. :

 

[Govind]

Hi Eithne,

Go to the cell G56 in Sheet 2 and enter this formula

=Sheet1!F45

This way the number in sheet 2 changes everytime the value in cell F45
of sheet 1 also is changed.

Regards

Govind.

 

[Jason Morin]

=Sheet1!F45

If you change Sheet1's name, the formula will adjust to
the name and still function correctly.

HTH
Jason
Atlanta, GA

 

[CarlosAntenna]

What Govind says will work.
You seem to be concerned about the name of Sheet1 changing. When the name
of sheet one changes, formulas referencing that sheet should be adjusted
accordingly. This happens automatically so you don't need to do anything.

Carlos