You can use a filter, then copy the results to a new sheet. Be sure to
select visible cells only once all you see is the Line Tech's.

Bob Umlas

"Troy" wrote in message
...
I have a list of people in my department in column 'A'. In column 'B' I
have
their job titles. I want to be able to list specific job titles on
different
sheets. For example :
John Smith Line Tech
John Doe Line Tech
Jane Doe Computer Analyst
Amy Smith Computer Tech
Stephanie Low Line Tech

How can I make excel list only the Line Techs on a different sheet?