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