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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
Click to expand...
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
 
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
 
Back
Top