Forum Discussion
Convert MPP into Excel file with transposition of every stage of sub-tasks in successive columns
Dear All,
I hope you are doing well and it's my first time ever in Microsoft forum
As explained in the subject title, I want to know if it's possible to convert MPP file into Excel file adding all it's sub-tasks in differents columns. Meaning that :
- all same tasks level are in the same columns
- the missing sub-tasks level are represented by empty cells
For example :
MPP view :
Excel view would be then :
Or even better like that (file ready to share :-)) :
I would really appreciate your help
Many thanks in advance
Kind regards
4 Replies
- Cashflowlimited,
Welcome to the forum. To answer your question, "yes" that can be done (either Excel format). There are at least two ways to do it. One, is tedious but effective and that is a copy and paste. The other is via VBA.
I don't quite follow your, "file ready to share [with emoji]" though. I personally think the first format is more readable. How about replication of the Project Task Sheet view, including outline level indents, in Excel? I already have a macro that does that.
JohnHi John,
Thanks for your quick feedback
By "file ready to share", I meant the second view I represented is my final target
But if I can get the first proposal (that is more readable), then I can modify it manually after all
You want me the share the whole project ? Or I can get macro you already created with some explanations ?
Sorry I'm not english native
Kind regards
- Cashflowlimited,
You're welcome and thanks for the feedback. If you are able and willing to share your file, that would be helpful. Then I can test the macro and make sure it works for you.
You can send me the file via e-mail to the address below. I will ask some questions.
John
jmacprojataticlouddotdotcom
(remove obvious redundancies)
