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?