information the same for cells on two different worksheets?
 

I am trying to get information i type in cells on worksheet A to also be
entered somewhere else on worksheet b. As I change info on sheet A I would
also like it to be changing on be so I dont have to reenter the data every
time. I know I have done this before, but can not remmember how. Any help
would be greatly appreciated even though I know I am going to feel silly when
I see how easy it is.

Thanks,

Rob

information the same for cells on two different worksheets?
 

Hi Rob

Assuming the info you want displyed is in cell A1 and you sheet names
are sheet1 sheet2 sheet3 etc try putting this in sheet2(or wherever you
want the info from sheet1 displayed)
=Sheet1!A1

This can be changed for whatever cells you need

Let me know how you go

Steel monkey


--
Steel Monkey
------------------------------------------------------------------------
Steel Monkey's Profile: http://www.excelforum.com/member.php...o&userid=29051
View this thread: http://www.excelforum.com/showthread...hreadid=571250

information the same for cells on two different worksheets?
 

that was it thank you sooooo much. I was forgetting the exclamation point.
errrrr I mean, I was forgetting the exclamation point!!!!

Thanks again Steel monkey, greeeeatly appreciated

"Steel Monkey" wrote:


Hi Rob

Assuming the info you want displyed is in cell A1 and you sheet names
are sheet1 sheet2 sheet3 etc try putting this in sheet2(or wherever you
want the info from sheet1 displayed)
=Sheet1!A1

This can be changed for whatever cells you need

Let me know how you go

Steel monkey


--
Steel Monkey
------------------------------------------------------------------------
Steel Monkey's Profile: http://www.excelforum.com/member.php...o&userid=29051
View this thread: http://www.excelforum.com/showthread...hreadid=571250