Lookup based on list of names

I need to import a file everyday that looks like this, but there are 250 people listed.
I want to be able to enter a formula that will look for just my team members based on a list, and either delete the other rows or put the data in a new sheet - whichever is easier.

The data looks as follows:

Entry Operator Orders Demand Avg Total Promo's Promo %
ABRAMS,TANJA 16 850.25 53.14 4 2500%
CONNOR,JASON 97 3,978.55 41.02 3 309%
COSGROVE,CAROL 260 14,057.88 54.07 54 2077%
CRISTINA,TINA 29 1,658.75 57.20 3 1034%
CROCKETT,BARBARA 32 936.42 29.26 7 2188%
DAVIS,ELIZABETH 50 2,448.10 48.96 7 1400%

Thanks for your help!!!
Tom

OK so lets say that the data is in sheet 1 so in sheet 2.
cola B
Abrams, Tanja =vlookup(a1,Sheet1!A1:F300,2,false) ' this will give
you the operator number...



Cesar Zapata


tojo107 wrote:

I need to import a file everyday that looks like this, but there are 250 people listed.
I want to be able to enter a formula that will look for just my team members based on a list, and either delete the other rows or put the data in a new sheet - whichever is easier.

The data looks as follows:

Entry Operator Orders Demand Avg Total Promo's Promo %
ABRAMS,TANJA 16 850.25 53.14 4 2500%
CONNOR,JASON 97 3,978.55 41.02 3 309%
COSGROVE,CAROL 260 14,057.88 54.07 54 2077%
CRISTINA,TINA 29 1,658.75 57.20 3 1034%
CROCKETT,BARBARA 32 936.42 29.26 7 2188%
DAVIS,ELIZABETH 50 2,448.10 48.96 7 1400%

Thanks for your help!!!
Tom