Linking a column on One worksheet to Multiple Pages in Another Doc
 

How to link for example Doc A Q7 to Doc B Page 1 ; Doc A Q8 to Doc B Page 2
and so on? I know there has to be a way to do this

Linking a column on One worksheet to Multiple Pages in Another Doc
 

Click the cell you want to link to another cell in another doc. Hit the
equals sign and click the tab/window for the other doc and click the cell you
want it to correspond to. Hit enter. That's it. If you do this three times or
so in a column on each page, you can highlight those cells and go to the
bottom right of the highlighted cells with your cursor (you will see a
plus-sign type icon) and drag it down. It'll repeat the pattern. There's
probably a formula for it, but I'm much too lazy for formulas.

"mark" wrote:

How to link for example Doc A Q7 to Doc B Page 1 ; Doc A Q8 to Doc B Page 2
and so on? I know there has to be a way to do this