Populate an array that is a subset of a larger array?

[Guest]

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

 

[Pete_UK]

It would be easier if you set up all sheets (tabs) identically, so if
you could have up to 10 resources (what a terrible word for people !!)
then all sheets would have 10 rows. Then on each sheet you could apply
a custom filter for not equal to zero on some column to hide those
people who were not contributing to that sheet.

Hope this helps.

Pete