Carry Over

[Chris]

I am trying to set up an excel spreadsheet so that when I type something in
A:1 of sheet1 it automatically shows the same thing in A:1 of sheet2 and A:1
of sheet 3. For example if i put my name in the first excel sheet i want it
to show up in all of the others too. I would greatly appreciate any help you
guys can give me.

 

[JE McGimpsey]

One way:

In sheet2, sheet3, etc.:

=Sheet1!A1

 

[Chris]

I realize that this is the way to do it but i am sorry because i failed to
mention something else. I am getting an Update values box whenever i try to
use this function, I do not understand why. It could possible be due to the
fact that i am trying to duplicate a box that is C3:N3. But i try to set a
name for Sheet1C3:N3 and i still am getting that box? Thank you for any help
you can give me with the lack of information i am presenting.

 

[Gord Dibben]

You cannot link a range.

On Sheet2 enter Sheet1!C3 then copy that across


Gord Dibben MS Excel MVP