J
Jeff
Can I programmatically using VBA do the following, and if so, how?
A). I want to filterout tasks inserted by the central resource pool.
i.e. the summary lines reporting the resources usage in other
published projects. the goal here is to get just the tasks related to
the project in question.
B). I want to change the resource usage sheet cell total to reflect
the filtering applied in question number A).
I have tried using the autofilter but I am not getting the totals of
of work to change to reflect the new subtotal of work. Also, I would
like to have this automated so that when I am resource loading a sheet
I can toggle back and forth between the original state and the new
totals
Thanks in advance
A). I want to filterout tasks inserted by the central resource pool.
i.e. the summary lines reporting the resources usage in other
published projects. the goal here is to get just the tasks related to
the project in question.
B). I want to change the resource usage sheet cell total to reflect
the filtering applied in question number A).
I have tried using the autofilter but I am not getting the totals of
of work to change to reflect the new subtotal of work. Also, I would
like to have this automated so that when I am resource loading a sheet
I can toggle back and forth between the original state and the new
totals
Thanks in advance