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

"Ego Id Pamela" wrote:

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!