A
Alex Bot
Hello,
Situation:
I'm using MS Project 2003. No Project Server. I have several (10+) subprojects linked to the Consolidated/Master project file. The structure is simple:
Subproject1
-- Design1
-- Develop1
-- Implement1
Subproject2
-- Design2
-- Develop2
-- Implement2
etc.
Each task has additional text custom fields (Text1 - Status, Text2 - Issues, etc.). The information in these fields is supposed to be entered by project managers of the subprojects, and should be available in the master file. Everything works fine at the level of individual tasks (Design, Develop, etc.). When data is entered in the text fields of the individual tasks from the subproject files, it can be seen in the individual tasks of the master file. Same works in the opposite direction - updates from the master file propagate to the subprojects.
Problem:
Text custom fields of the Summary Tasks of the Master Project (i.e. subproject1, subproject2, etc.) do not get updates when text fields of the summary tasks of the subprojects are changed. These updates are necessary because information from these cells of the master project summary tasks will be exported into Excel for further processing/reporting.
Question:
Is there a way to link the text custom fields of the summary tasks (top-level) of the subprojects to the summary tasks of the master file?
If that?s impossible, maybe another option. In the subproject files, updates will be entered in the text fields of the first individual tasks under the summary tasks. These updates are available in the master file. Maybe there?s a macro that could be applied to the master file and perform something like that:
- search for the next summary task (not indented)
- go to the individual task immediately following the summary task
- copy info in the text field of the individual task
- paste info in the text field of the summary task
- continue to the next summary task.
Thanks.
Alex
Submitted via EggHeadCafe - Software Developer Portal of Choice
Sending SMTP email from within BizTalk Orchestration
http://www.eggheadcafe.com/tutorial...f-1716445b26bc/sending-smtp-email-from-w.aspx
Situation:
I'm using MS Project 2003. No Project Server. I have several (10+) subprojects linked to the Consolidated/Master project file. The structure is simple:
Subproject1
-- Design1
-- Develop1
-- Implement1
Subproject2
-- Design2
-- Develop2
-- Implement2
etc.
Each task has additional text custom fields (Text1 - Status, Text2 - Issues, etc.). The information in these fields is supposed to be entered by project managers of the subprojects, and should be available in the master file. Everything works fine at the level of individual tasks (Design, Develop, etc.). When data is entered in the text fields of the individual tasks from the subproject files, it can be seen in the individual tasks of the master file. Same works in the opposite direction - updates from the master file propagate to the subprojects.
Problem:
Text custom fields of the Summary Tasks of the Master Project (i.e. subproject1, subproject2, etc.) do not get updates when text fields of the summary tasks of the subprojects are changed. These updates are necessary because information from these cells of the master project summary tasks will be exported into Excel for further processing/reporting.
Question:
Is there a way to link the text custom fields of the summary tasks (top-level) of the subprojects to the summary tasks of the master file?
If that?s impossible, maybe another option. In the subproject files, updates will be entered in the text fields of the first individual tasks under the summary tasks. These updates are available in the master file. Maybe there?s a macro that could be applied to the master file and perform something like that:
- search for the next summary task (not indented)
- go to the individual task immediately following the summary task
- copy info in the text field of the individual task
- paste info in the text field of the summary task
- continue to the next summary task.
Thanks.
Alex
Submitted via EggHeadCafe - Software Developer Portal of Choice
Sending SMTP email from within BizTalk Orchestration
http://www.eggheadcafe.com/tutorial...f-1716445b26bc/sending-smtp-email-from-w.aspx