Thread: WORKSHEETS
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
John[_22_] John[_22_] is offline
external usenet poster
 
Posts: 694
Default WORKSHEETS

Hi
If you put this formula: =Sheet1!A1, anywhere in other worksheets, it
will give you exactly what you want. Sheet1 is the original name of the Tab,
change it to your if they've been changed.
HTH
John
"Boyertown Casket" wrote in
message ...
I did this before; however, I have not utilized it for so long I forget
how
to do it.

I want a particular cell's content (in the first worksheet) to be
displayed
in other different locations in multiple worksheets.

First worksheet in cell A:1 contains '12 JAN 09'

I want to be able to take what is displayed in A:1 and display it in any
other worksheet and in various locations on those worksheets. Then, when
cell A:1 is changed / edited / modified, the other cells in the other
worksheets will reflect the new information too.

I am not sure if it was PLUS or what to do this. I can't find PLUS
anywhere
in Help so that might not be it. Of course, I may have been in a
different
version of Excel too. Like I said, I know I did it, but I forget what I
did
to make it work.

Any help would be appreciated. Thank you.