Dynamic Links/ linking numerous pages on spreadsheet

  • Thread starter Thread starter FKK
  • Start date Start date
F

FKK

I was hoping someone could help me. I have 7 pages on a
spreadsheet the first is the main and pages 2-7 are each
sections from the main. I need to know if there is a
formula that I can use so that when I make changes to the
first page it changes on the page relating to that
section. I was told it is called a dynamic link but who
knows that could be wrong. Please help I need this
urgently.
Thanks
 
FKK,

All you need to do is use a formula in the cell where you want the
information to appear. So, in Sheet7 cell B2, say, use a formula like

=Sheet1!A1

And any time you enter something into cell A1 on Sheet1, it will
appear in B2 of Sheet7.

Instead of typing it in, you can simply type the = sign, then click on
the tab of the first sheet and select the cell you want to pull the
value from, then hit enter.

HTH,
Bernie
MS Excel MVP
 
Back
Top