Creating list from values that meet multiple criteria from other sheet
 

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

I now have this question and have not been able to find an answer to it 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 AND 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 to have this in a totally different sheet.

And I plan to use different criteria in different columns.

Thank you in advance for the help.

Creating list from values that meet multiple criteria from other sheet
 

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?...182 2A3%21201
In sheet2 you can enter your criteria in B3:G3


Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2