Populating text custom fields of the summary tasks in a Master Project

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
 
R

Rod Gill

Unfortunately, Project does not update custom fields for sub-projects and
Master files. A VBA macro is your only solution, but it's a fairly simple
one.

--

Rod Gill
Microsoft MVP for Project - http://www.project-systems.co.nz

Author of the only book on Project VBA, see: http://www.projectvbabook.com




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

__________ Information from ESET Smart Security, version of virus
signature database 4852 (20100209) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4852 (20100209) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top