Single column Indenture from MS Project to Excel

[carias76]

I am trying to keep the indenture that MS Project has when I export to
Excel. I have seen several macros that indent by moving the indenture
into the next cell. I want to keep all of the task names in one column

and indent with spaces so that I can do searches and filters on all of
the tasks names at once. Is there a way to do this automatically?
I also want to know if anyone has a macro that can add spaces to the
task name based on the outline code.

Thanks,


Carlos

 

[Ratheesh]

Apologize for the wrong answer it was meant for the previous question ..

 

[Ratheesh]

Microsoft is not having any plans to make MS Project for the Mac any time in
the near future

Here is some things you can try

The software is LeadingProject by csodessa - It uses MS project XML files -
Please follow this link
http://www.leadingproject.com/en/products/project/overview.php

Hope this helps

 

[Jan De Messemaeker]

Hi,

Much simpler is to export the Outline level field
For people knowing the Excel formulas it can't be very difficult to
concatenate so many spaced with the exported name:;
HTH

 

[Jan M.]

Hi Carlos,

Here's a two step process that works fine:

1) Save your file as a Web Page (File/Save as a Web page)
2) Open the Web page, copy and paste in Excel.

The pasted data will keep the format of the web page(indenture, bold police
for summary tasks...)

Jan M.

 

[Jim P]

Carlos,
I am not quite sure I understand the issue. If you have thee columns in
your Excel spreadsheet as follow:

Column A - Outline Level
Column B - Task Name
Column C - Task Name reformatted using a formula
A formula that would insert 3 spaces for each level of the outline
is
=REPT(" ",(A2-1)*3)&B2
This formula could be copied to each row, thus Column C has all of
the tasks with leading spaces.

Using this you can hide column B and search in any way you desire using
Column C.

Am I missing part of the requirement? No one would ever need to see
Column B once the task names are copied from Project.

Similarly, you could use two worksheets to avoid the hidden column
issue. "Sheet1" would have the data in Excel as you want to display it
and "Sheet2" would have the data as you import it. Thus you could paste
in the tasks at any time into "Sheet2" and the formulas in "Sheet1"
would not be affected. Using this approach the formula on "Sheet1" to
reformat the task name would be, =REPT(" ",(Sheet2!B2-1)*3)&Sheet2!C2.
This formula assumes the Outline Level value is in column 2 of sheet2
and the task name is in column 3 of sheet2.

Jim Peters