Sheet: Excel Filtering

[jmorovich]

I have a Excel 2003 file that has 8 worksheets with about 45,000 lines of data in each worksheet. The data is an employee list with hours worked, employee number, total amount paid, last name, and first name. There is about 1000 employees in this list and i need to filter it out to get only the 150 I need data on. I have the employee numbers that I need. Currently I am doing the Auto-Filter on the employee number column, selecting the ONE employee number, and cutting and pasting it to another worksheet. I would have to do this 150 times for all 8 worksheets!! There has to be an easier way to filter all of this data only once to get the employee numbers I need.
Does anyone know of an advanced filter or macro that would allow me to do this or add-in software?

I'm an Excel Newbie and any help with this would be greatly appreciated!

Thanks again...

[Carim]

Hi,

See attached sample worksheet where filtered results appear in Result sheet ...

[jmorovich]

Carim,
Thanks for the quick response! However in looking at the example you gave me it only give me the option to filter one item at a time, much like what I'm doing now. Is there a way to take the example you gave me and sort on 150 items at once?

Thanks again!

[Carim]

Hi,

If your 150 items are stored in your worksheet, adding a loop to go through each of the 150 items will produce the result expected ...