Creating list from values that meet multiple criteria from other sheet

[Gmo305]

Hello everyone, my name is Guillermo and I'm new to the forum. I hav
some experience with excel and work with excel but simply go alon
learning what I have to use on the web.

I now have this question and have not been able to find an answer to i
anywhere.

So,
I have a sheet in excel that is filled out. Lets say from A1:F5

Ex.
Name Status Program Contracter Date Station
John 1st Medical Doe 1-may Miami
Bob 1st Cook Sagget 5-may WPB
Rick 1st Medical Ross 10-may FTL
Will 3rd Driver Smith 16-may
Miami

So I would like to form a list starting in a DIFFERENT Sheet column B
cell B1 , that meet certain criteria, and continue down B1, B2, B3 etc
until there are no more left .

So Lets say I wanted all the names of those in Program= Medical AN
Status= 1st listed, I would get in cell B1= John and B2= Rick

I do not with to set filters, I need the original list as is and want t
have this in a totally different sheet.

And I plan to use different criteria in different columns.

Thank you in advance for the help

 

[Claus Busch]

Hi Guillermo,

Am Mon, 14 May 2012 16:23:55 +0000 schrieb Gmo305:

Name Status Program Contracter Date Station
John 1st Medical Doe 1-may Miami
Bob 1st Cook Sagget 5-may WPB
Rick 1st Medical Ross 10-may FTL
Will 3rd Driver Smith 16-may
Miami

So I would like to form a list starting in a DIFFERENT Sheet column B,
cell B1 , that meet certain criteria, and continue down B1, B2, B3 etc.
until there are no more left .

try it with advanced filter and VBA.
Take a look:
https://skydrive.live.com/view.aspx?cid=9378AAB6121822A3&resid=9378AAB6121822A3!201
In sheet2 you can enter your criteria in B3:G3


Regards
Claus Busch