Propagation from sub-projects to Master Project

[Luc Gestin]

I have a Master Project schedule and inserted sub-projects (with the MS
Project Insert function).

I have linked milestones in sub-projects (sub-project milestone) to
milestones in Master Project (Master Project milestone).

When I update a sub-project milestone at 100% complete, there is no impact
on the linked Master Project milestone. I was expecting that this Master
Project milestone would automatically become 100% complete.

It seems that %Complete data gets propagated between sub-projects and Master
Program only when I use Copy Cell/Paste Special/Link Data function on the
%Complete field.

Any advice would be very much appreciated. Thanks.

Kind regards.

 

[Jan De Messemaeker]

Hi,

This is not a matter of subprojects.
A %complete on a predecessor does not influence a successor and vice versa.
HTH

 

[Luc Gestin]

Jan, Thank you so much. Agreed with your response.

Let me rephrase my question: my Master Project include key milestones from
the various sub-projects. I'd like to update the Master Project milestones
based on progress made on the sub-progress milestones.

What is the best solution with MS Project Professional 2003?

Merci bien.

 

[Jan De Messemaeker]

Bonsoir Luc,

Cela n'est pas évident.
The only possibility I see is to write a (non-trivial) VBA procedure that
updates a milestone to 100%complete when all its (milestone) successors are
100% complete.
Project "out of the box" will not do this.

 

[Luc Gestin]

merci bien Jan.

re: propagating % Complete for one sub-project milestone to one Master
Project milestone (one-to-one milestone propagation), can we use "Copy Cell"
plus "Paste Special/Link Data" on the %Complete field of the sub-project
milestone?

Is a VBA macro still better for one-to-one milestone propagation?

Kind regards.
Luc

 

[Jan De Messemaeker]

Hi Luc,

Happy you found such an elegant solution, hadn't thought of that.
A VBA procedure could be more generid, if you add such milestone links
later, running the macro would automatically handle these as well.
But it probably isn't worth it since you have a semi-automatic solution!
Bien à toi,

 

[Luc Gestin]

Merci bien Jan et bon weekend