Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Linking... is this possible | Links and Linking in Excel | |||
Linking | Excel Discussion (Misc queries) | |||
I think Linking | Excel Discussion (Misc queries) | |||
Help with linking | Links and Linking in Excel | |||
New to Linking | Links and Linking in Excel |