Thread: Titles
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Troy
 
Posts: n/a
Default Titles

Ya, I could do it that way but I wanted to select the different sheet from
the tabs on the bottom and on this different sheet show only the titles
listed on the tab. Which would be 'Line Tec', 'Computer Analyust', etc. I
have tried VLOOKUP but it doesn't quite do what I am looking for. I'm sure
there is a way but I don't know how.

"Bob Umlas" wrote:

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?