filtering

[Lynn]

how do i filter tasks that is called taskC, and also display all its
subtasks?

 

[JulieS]

Hello Lynn,

Likely the fastest way is to insert one of the spare Flag fields
(Flag1) into the table. Set the Flag to TaskC to yes, use the fill
handle to copy the "yes" to the subtasks. Then you can use
autofilters to filter for "Yes".

I hope this helps. Let us know how you get along.

Julie
Project MVP

Visit http://project.mvps.org/ for the FAQs and additional
information about Microsoft Project

"Lynn" > wrote in message
news:e0563e6b-97e9-4278-a58f-7e9b3d962f52@r24g2000vbn.googlegroups.com...

 

[Lynn]

Hi, flag is not usable for me as I will need to filter for different
tasks at different time.

Any other means?

 

[Rob Schneider]

Lynn,

Another approach would be create a filter which uses the "contains" as
the test. For the tasks that emerge, then simply open up all the
relevant subtasks.

 

[JulieS]

Hi Lynn,

If I understand your question, the primary problem is that the
subtasks of TaskC do not have "TaskC" in their names, so filtering
for the text "TaskC" won't show the subtasks.

The other suggestion I can make is to use a macro to copy the
summary task information for each task into a text field and then
filter on that field. Luckily, Jack Dahlgren (Project MVP) has
posted a macro that copies the summary task name for each task into
a spare text field. See:
http://masamiki.com/project/macros.htm

and find the "SummaryTasks" macro. Jack's macro will copy the
summary task information into Text12. Once you've run the macro,
you can then create a custom filter searching for tasks which
"contain" TaskC in text 12.

You can also create a filter that will allow you to enter the
specific task name criteria when run. The criteria for the filter
would be:

Field Name: Name
Test: contains
Values: "Enter part of task name"?

I hope this helps.

Julie

in message

 

[Lynn]

Hi, not able to find "SummaryTasks" macro

Hi Lynn,

If I understand your question, the primary problem is that the
subtasks of TaskC do not have "TaskC" in their names, so filtering
for the text "TaskC" won't show the subtasks.

The other suggestion I can make is to use a macro to copy the
summary task information for each task into a text field and then
filter on that field.  Luckily, Jack Dahlgren (Project MVP) has
posted a macro that copies the summary task name for each task into
a spare text field. See:http://masamiki.com/project/macros.htm

and find the "SummaryTasks" macro.  Jack's macro will copy the
summary task information into Text12.  Once you've run the macro,
you can then create a custom filter searching for tasks which
"contain" TaskC in text 12.

You can also create a filter that will allow you to enter the
specific task name criteria when run.  The criteria for the filter
would be:

Field Name: Name
Test: contains
Values: "Enter part of task name"?

I hope this helps.

Julie

in message







- Show quoted text -

 

[Rob Schneider]

What steps did you take to go look for it? try to be as specific as
possible.

 

[JulieS]

Hello Lynn,

It's on the web page I directed you to down under the heading
Working with Task Data.

Julie

"Lynn" > wrote in message
Hi, not able to find "SummaryTasks" macro