![]() |
Linking From One Doc to Another Doc?
I'm trying to link one document to multiple pages. For example I have a list
in document A with rows going across with numbers in them and I want docment B Which has a pages for each item in docment A to pull the right numbers from Doc A and place them in the corresponding cell on Doc B. |
Linking From One Doc to Another Doc?
There's probably a shorter way to do this, but I do it manually.
Okay, let's say you want column A from Doc A to be identical to column B in Doc B. In Doc B, column B, in the first cell, insert the equal sign and click the tab to get over to Doc A and click the first cell in column A. Hit enter. Magic. Now, just do the same thing for the corresponding cells one or two more times. If you want it to go down farther in the same pattern in Doc B, highlight the few cells you already did (click and drag) and then release. Point your cursor to the bottom right of the highlighted portion, and you will see a plus-type of sign. Now, drag your cursor down. It will have repeated the pattern. "mark" wrote: I'm trying to link one document to multiple pages. For example I have a list in document A with rows going across with numbers in them and I want docment B Which has a pages for each item in docment A to pull the right numbers from Doc A and place them in the corresponding cell on Doc B. |
All times are GMT +1. The time now is 05:45 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com