Filtering for 100% Predecessors

[TanyaE]

I'm trying to filter my plan so that the end result is a list of tasks whose
predecessors are all complete. Some of these tasks have 5 or more
predecessors, so I don't want to know about it, unless all 5 predecessors are
100%. Can anyone help me.

 

[Jan De Messemaeker]

Hi Tanya,

There may be other methods, but I would do that with a VBA procedure:

Sub ForTanya()
Dim T1 as task
Dim T2 as task
for each T1 in activeproject.tasks
if not t1 is nothing then
t1.flag7=true
for each t2 in t1.predecessortasks
if not t2.percentcomplete=100 then t1.flag7=false
next t2
end if
next t1
end sub

Copy this into VB Editor, run it, then filter for Flag7 equals Yes.
HTH

 

[TanyaE]

Many thanks. It worked perfectly and saved me alot of time.
Cheers.

 

[Jan De Messemaeker]

You're welcome!