Milestone rollup in tabular format

M

MFK

Is there a simple way to display all project milestones rolled up into
a single row in *tabular* format? I know that MS Project can do a
rollup in *graphical* format with the Rollup formatting macro, but I
want the result to be tabular data, i.e. fields of data organized into
rows and columns, so that it can be exported to e.g. Excel.

I know how to do this by coding milestone tasks and performing a SQL
query on back-end data tables, but I'm trying to avoid all that
overhead if possible.

Thanks,
Mitch
 
J

J Baird

You want the milestone dates on one row, rather than vertically listed? You
could filter them, paste them in Excel, then transpose them from vertical to
horizontal format.

1) Filter your view for milestones, select them, and and click [Edit][Copy
Cell]
2) Go into Excel, click on a cell, and select [Edit][Paste Special][Text]
and click [OK].
3) Still in Excel, click [Edit][Copy], click on a cell in a blank area and
click [Edit][Paste Special] click [Transpose] and click [OK].
 
J

J Baird

FYI: Excel's right most column limit is Column IV (256 cols). You can't
display more than 256 milestone dates on one line in Excel, unless you have
1 date in each cell.
Click to expand...

J Baird said:
You want the milestone dates on one row, rather than vertically listed? You
could filter them, paste them in Excel, then transpose them from vertical to
horizontal format.

1) Filter your view for milestones, select them, and and click [Edit][Copy
Cell]
2) Go into Excel, click on a cell, and select [Edit][Paste Special][Text]
and click [OK].
3) Still in Excel, click [Edit][Copy], click on a cell in a blank area and
click [Edit][Paste Special] click [Transpose] and click [OK].

MFK said:
Is there a simple way to display all project milestones rolled up into
a single row in *tabular* format? I know that MS Project can do a
rollup in *graphical* format with the Rollup formatting macro, but I
want the result to be tabular data, i.e. fields of data organized into
rows and columns, so that it can be exported to e.g. Excel.

I know how to do this by coding milestone tasks and performing a SQL
query on back-end data tables, but I'm trying to avoid all that
overhead if possible.

Thanks,
Mitch
Click to expand...
Click to expand...
 
Top