Linking question

[Cacoe]

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

I have a workbook that has many pages that have nearly the same information on every page. I don't like having to input the same information multiple times when I update each page. I would like to be able to type it in on the first page and have the rest of the pages 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 to 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
--
AP

"Cacoe" <[email protected]> a écrit dans le
message de news: [email protected]...
>
> First off, I'm unsure whether or not linking is the correct
> terminology.
>
> I have a workbook that has many pages that have nearly the same
> information on every page. I don't like having to input the same
> information multiple times when I update each page. I would like to be
> able to type it in on the first page and have the rest of the pages
> 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 to
> make it work for text.
>
> Any help is appreciated.
>
> Thanks.
>
>
> --
> Cacoe
> ------------------------------------------------------------------------
> Cacoe's Profile:
> http://www.excelforum.com/member.php...o&userid=28894
> View this thread: http://www.excelforum.com/showthread...hreadid=545163
>

[Cacoe]

Just type:
=Sheet2!B12

That will copy the contents of Sheet2 cell B12

HTH
--
AP

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

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