I am trying to link

[Ego Id Pamela]

I am working with an old template that's been used over and over again
however my boss wants to finally perfect it..so she has changes that need to
made. I am trying to link a cell from worksheet #1 to worksheet #2...so when
I write something in lets
say B2 in worksheet#1 it will say the same thing in B2 on worksheet#2. I am
trying to prevent having to write the same thing over and over again so I
just write in once it will already be there on the other worksheet? I've been
trying to figure this out like mad!!! please help! i need that formula.
thanks!

 

[Pimamedic]

in Worksheet2 CEll B2 try this =Sheet1!A1 change A1 as needed and copy down

 

[Ego Id Pamela]

It's not working.

I am trying to do this: I am trying to write a formula that can link one
cell to the other.. So if i were to write something in the first cell it
would already be written in the second sheet with that same information. I am
trying to copy the other formulas on the sheet but for some reason its still
not working. Any help or another formula?