Linking Cells

[ASH]

I am trying to get a spreadsheet to link cells. In other
words, when I enter data into a cell on the first page, I
want the same info to appear in several other pages within
the same workbook. When the info is changed, it will
update all other instances that are linked.

I know it can be done, I just cannot figure out how!!

Thanks in advance for your help.

 

[Randy Rich]

I think the easiest way is to copy the original cell using
whatever method you like. Go to the destination and do
a "Paste Special" and select "link" from the options. It
puts in the fully qualified name information it needs to
make the link active. If you are moving between different
sheets, you may need to use F9 every now and then to
refresh the info. Good Luck! - Randy