How to setup a column containing the summary name for each task?

[ellebelle]

I want to insert a new column that contains the summary name of each task
Therefore I can export the column to an excell spreadsheet that has the name
of a task, the resource name and the summary task all on ONE row.

 

[Steve House [Project MVP]]

AFAIK there's no way to do that, sorry.

 

[davegb]

Sorry to disagree with you, Steve, but I think this could be done using
by putting the summary task name in a custom text field. If there are a
lot of tasks in the Project, it would require a lot of time or a VBA
macro.

 

[ellebelle]

when you are in Gant Chart View you are not given teh option to incllude a
Summary Task Name in a custom text field.

You can do this if you are in the 'resource usage' view, however then you
will get the resource name in hte same column as the task name and you are
back where you started.

I want one row with the resource name. task name and sumary name on it.

 

[Jan De Messemaeker]

Hi,

The VBA macro youneed is quite simpel:

Sub SummName
dim job as task
for each job in activeproject.tasks
if not job is nothing then
if not job.outlinelevel=1 then
job.text7=job.outlineparent.name
end if
end if
next jopb
end sub

HTH

 

[ellebelle]

It worked! Thanks a lot.....

Hi,

The VBA macro youneed is quite simpel:

Sub SummName
dim job as task
for each job in activeproject.tasks
if not job is nothing then
if not job.outlinelevel=1 then
job.text7=job.outlineparent.name
end if
end if
next jopb
end sub

HTH




--
Jan De Messemaeker
Microsoft Project Most Valuable Professional
http://users.online.be/prom-ade/
+32-495-300 620

 

[Jan De Messemaeker]

You're welcome.