Hi,

I am trying to pull information from an array that contain these
information. I need to be able to pull the information if the status is
'OPEN' along with the module name and start date. However, I can't do a sort
because these modules are in separate projects which are right on top of each
other, so to sort would throw everything else off. I tried using vlookup in
array form, which kind of worked but it lagged the entire worksheet to almost
unbearable lengths and it did not update automatically. Is there some vba
code or some other way to do it? Pivot tables are also very difficult to use
in this case because there are many hidden columns of calculations between
each requirement I need to pull out

Status Module Start Date
Open B 8/12
Close A 8/15
Open C 8/11
Open B 8/12

Thanks