GallowayJay
New Member
- Joined
- Apr 8, 2002
- Messages
- 15
Simple question to the gurus.....
I am working on a project as follows: each individual data module will be contained in its own Excel FILE. Within each file there will be text boxes created for the user to enter analysis in a word format. There will be a master Excel file that is intended to pull specific data from each of the individual Excel module files. Some of this data will come from those text boxes.
My question, how can I link the contents of the text box from the "sub" Excel file, and bring it into the "master" Excel file? I don't want to be copying and pasting text boxes. I know there has to be an easier way.
Hopefully this is self explanatory. Thanks!
GallowayJay
I am working on a project as follows: each individual data module will be contained in its own Excel FILE. Within each file there will be text boxes created for the user to enter analysis in a word format. There will be a master Excel file that is intended to pull specific data from each of the individual Excel module files. Some of this data will come from those text boxes.
My question, how can I link the contents of the text box from the "sub" Excel file, and bring it into the "master" Excel file? I don't want to be copying and pasting text boxes. I know there has to be an easier way.
Hopefully this is self explanatory. Thanks!
GallowayJay
