Sort Summary Bars by Detail Task Data?

W

Waz

I posted this question earlier on the "General" forum and didn't get a
response, so I am trying here (although I know next to nothing about VBA so
please have pity on me).

I have several small sub-projects in one file (Project 2003). Each subproject
is represented by a summary bar with tasks underneath, and each contains the
same 8 activities. The activities are linked FS within each subproject and
there
are no links between subprojects. I have created bar styles to roll up the
individual activities to their respective summary bars.

What I would like to do now is sort the summary bars not by their earliest
start date, but by the start date of the sixth “child†activity in the string
of activities
underneath them.

I think the solution might entail using VBA to somehow copy the start date
of the desired task up to the summary level. On Jack Dahlgren’s page I saw a
macro to copy data from the summary level activity to the lower level tasks.
Can the opposite be done – copy from the lower level to the summary level?
 
J

Jack Dahlgren

Waz said:
I posted this question earlier on the "General" forum and didn't get a
response, so I am trying here (although I know next to nothing about VBA so
please have pity on me).

I have several small sub-projects in one file (Project 2003). Each subproject
is represented by a summary bar with tasks underneath, and each contains the
same 8 activities. The activities are linked FS within each subproject and
there
are no links between subprojects. I have created bar styles to roll up the
individual activities to their respective summary bars.

What I would like to do now is sort the summary bars not by their earliest
start date, but by the start date of the sixth “child†activity in the string
of activities
underneath them.

I think the solution might entail using VBA to somehow copy the start date
of the desired task up to the summary level. On Jack Dahlgren’s page I saw a
macro to copy data from the summary level activity to the lower level tasks.
Can the opposite be done – copy from the lower level to the summary level?

Certainly it can. However, there are many lower level tasks. Which value of
which task would you want to roll-up? How do you know which one of the
subtasks is the one you want to move to the summary?

-Jack Dahlgren
 

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