| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically separating worksheet into multiple pages | Excel Discussion (Misc queries) | |||
| How do I sort multiple worksheet pages to list in numerical order? | Excel Worksheet Functions | |||
| Linking multiple pages | Excel Discussion (Misc queries) | |||
| Linking multiple data into one worksheet. | Excel Worksheet Functions | |||
| Single worksheet, multiple pages? | Excel Discussion (Misc queries) | |||
Threaded Mode
