HunterN
Active Member
- Joined
- Mar 19, 2002
- Messages
- 479
Hi All You Excel People,
Here is an example of my Master Workbook:
Most is column headings, the two numbers go under Project Number, I can have many projects. (It doesnt look good when I submit it!)
FY 2002 CUMULATIVE COST ANALYSIS
MONTH BRANCH BRANCH PROJECT PROJECT
NUMBER CHIEF NAME NUMBER
--------------------------------------------- 7501 0251
"
I can go in and enter the Project Number in each row using another worksheet that holds the project numbers. There is also seperate workbooks for each Project that contains the other information that I need (plus more).
I need a way to move down the worksheet thru the Project Number column and use this
Project Number to open its appropriate workbook and retrieve the values from the Wkb
and enter them in the cells then move down to the next Project.
Has anyone done anything similar to this?
Your help would be appreciated. Thanks
This message was edited by HunterN on 2002-04-23 07:21
Here is an example of my Master Workbook:
Most is column headings, the two numbers go under Project Number, I can have many projects. (It doesnt look good when I submit it!)
FY 2002 CUMULATIVE COST ANALYSIS
MONTH BRANCH BRANCH PROJECT PROJECT
NUMBER CHIEF NAME NUMBER
--------------------------------------------- 7501 0251
"
I can go in and enter the Project Number in each row using another worksheet that holds the project numbers. There is also seperate workbooks for each Project that contains the other information that I need (plus more).
I need a way to move down the worksheet thru the Project Number column and use this
Project Number to open its appropriate workbook and retrieve the values from the Wkb
and enter them in the cells then move down to the next Project.
Has anyone done anything similar to this?
Your help would be appreciated. Thanks
This message was edited by HunterN on 2002-04-23 07:21