Alternative View to a Schedule - Need Help!

[BillV]

All,

Is there a way to write a macro to take the identified Milestones listed
below a summary task in a schedule, Create Columns labeled/titled with those
same Milestones and fill in the corrosponding Finish Dates? This particular
schedule has underneath each Summary Task the same Milestones/subtasks,
basically everything is duplicated.

My bosses boss has requested this kind of view. I know many will say just
create an Excel Spreadsheet but, we want to do this view in Project and it
seems it would be faster if a macro where created.

If anyone out there thinks they can help and need to see the Schedule, I
will be happy to send it to them.

 

[Jack Dahlgren]

It is possible using only custom fields (no macros) if you are willing to
use up a number of your text fields and flag fields.
How many milestones do you expect?

-Jack Dahlgren

 

[BillV]

21 Milestones are being tracked. I'm working on the custom fields approach
right now but, it would be nice to know if a macro can make this request
possible. I'm sure I'll have to do fulfill this request on more than one
schedule.

 

[Jack Dahlgren]

Bill,

To display the values in columns you need to use a field. Therefore if you
have twenty one milestones you are going to burn up 21 text fields or date
fields.

If you are using a text field for example, use a formula which determines if
the task is the specified milestone (use an iif() statement for example) and
if it is, then display the date, otherwise display nothing. Then for the
summary task just roll up the maximum value from the subtasks.

Using a macro would allow you do to something similar, but with a bit more
flexibility, but at the cost of having to run the macro whenever you want
the data to refresh.

I'd start with the custom field approach first.

-Jack Dahlgren