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

Hi,

You need to look at Advanced Filtering in Excel's help. For me to walk you
through it would be cumbersome and confusing. But I just tried it and it
took me a couple of minutes to set up. If I understand your requirement I
got the results you were looking for.

If this helps, please press Yes,
John

"Modawg" wrote:

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

Sorry, I should have worded my question differently. Being up late really
messes with that. What I am trying to do is to scan and pull the earliest 15
or 20 dates if a criteria is met (OPEN). If it the module is open, it and the
start date will automatically load itself on another worksheet in the same
workbook. The list would automatically update itself, so as a module was
closed, the next open one chronologically, would open up. I can't do sort
because the production sheets are lined by project. Essentially, I'm trying
for excel to scan, and put the data in a new sheet without sorting the
original data.

"JCS" wrote:

Hi,

You need to look at Advanced Filtering in Excel's help. For me to walk you
through it would be cumbersome and confusing. But I just tried it and it
took me a couple of minutes to set up. If I understand your requirement I
got the results you were looking for.

If this helps, please press Yes,
John

"Modawg" wrote:

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