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.

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