Populate an array that is a subset of a larger array?
Hello,
I am working on creating a template that my company can use for tracking
work done on projects. what I would like is to be able to have a tab that
tracks resource allocation on the project. That tab would include all
possible resources (people) that may work on the project.
I would then like to be able to select on a column "Allocation", everyone
0% would be picked up and listed in a new tab. The tricky part, I think, is
that I would like the new Array being created to be variable meaning that if
10 resources meet the criteria the array created would be 10 rows but if only
4 did only four rows would be inserted into the sub array.
Is this possible?
Thanks ahead of time.
Jeff
--
Jeff
|