Linking question

[Cacoe]

First off, I'm unsure whether or not linking is the correc
terminology.

I have a workbook that has many pages that have nearly the sam
information on every page. I don't like having to input the sam
information multiple times when I update each page. I would like to b
able to type it in on the first page and have the rest of the page
update automatically. I have resolved part of it by using the 'sum
function on numbers and dates, but I can't seem to figure out how t
make it work for text.

Any help is appreciated.

Thanks

 

[Ardus Petus]

Just type:
=Sheet2!B12

That will copy the contents of Sheet2 cell B12

HTH

 

[Cacoe]

Just type:
=Sheet2!B12

That will copy the contents of Sheet2 cell B12

HTH

I had an "Update Values" box pop and then it worked.

Thanks a bunch. This'll save me a lot of work.