Exporting MS Project 2007 Tasks to MS Excel with Indenting
26th January, 2012 – 2:12 pmApparently MS Project 2010 fixes this issue but I’ve often wanted to copy the tasks complete with the indenting to Excel to provide a quick and dirty report for non-project users.
When you use copy and paste you loose the formatting – grrr! Here is a quick and dirty solution.
- Insert column into Project (right click on the grey header bar above your tasks and choose Insert Column
- Select Field Name: Outline Level
- Now select and copy your tasks including this column to Excel.
- For my formulas Col A = ID, Col B = Outline Level, Col C = task name, adjust yours accordingly!
- Insert in the next free column the following formula =CONCATENATE(REPT(” “,B1-1),C1)
- There you go – quick and dirty as I said!