M
meg99
using 2007. I am trying to automatically count and sum margin in a
schedule via a macro. The margin tasks are identified with the word
"margin" in the title. However, the tasks are scattered thoughout
the
the 1000 task schedule and several of them are in parallel with
regard
to the dates/durations.
I can count the margin tasks easily enough, but I need to sum the
durations while eliminating those in parallel so I don't double or
tripple count the effective margin.
One way would be to put the start and finish dates into an array as I
identify the task as margin and compare to tasks already found etc.
Would this be the way to go or is there a better more elegant way?
regards,
Glen
schedule via a macro. The margin tasks are identified with the word
"margin" in the title. However, the tasks are scattered thoughout
the
the 1000 task schedule and several of them are in parallel with
regard
to the dates/durations.
I can count the margin tasks easily enough, but I need to sum the
durations while eliminating those in parallel so I don't double or
tripple count the effective margin.
One way would be to put the start and finish dates into an array as I
identify the task as margin and compare to tasks already found etc.
Would this be the way to go or is there a better more elegant way?
regards,
Glen