View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jeff Jeff is offline
external usenet poster
 
Posts: 921
Default 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