VBA Rolling Wave Baseline

[Bruce McF]

Would like to update the baseline as each iteration is completed ... freezing
the next iteration baseline and saving an updated baseline for tasks beyond
that next iteration. Also would like to select newly added tasks (usually
from splitting a larger previously-baselined task) and add them to the
baseline.

Key is selecting the appropriate tasks. Updating the baseline thereafter is
straightforward for the selected tasks.

Any guidance?

Thanks,
Bruce

 

[John]

Would like to update the baseline as each iteration is completed ... freezing
the next iteration baseline and saving an updated baseline for tasks beyond
that next iteration. Also would like to select newly added tasks (usually
from splitting a larger previously-baselined task) and add them to the
baseline.

Key is selecting the appropriate tasks. Updating the baseline thereafter is
straightforward for the selected tasks.

Any guidance?

Thanks,
Bruce

Bruce,
Maybe I don't quite understand what you want but it sounds like
"selecting the appropriate tasks" is something you should be able to do
very easily if you use a spare flag field to identify them as they are
created. Then select tasks with the flag and set a baseline. I don't see
a need for VBA.

I'm also a little confused as to the difference between "freezing" a
baseline and "saving" a baseline. In my mind they are the same thing.

John
Project MVP