Just some more suggestions.

Only update the one master worksheet list. And refresh the other sheets
whenever you want. It'll make life much simpler than trying to keep stuff in
sync.

And Ron de Bruin has an addin that you may want to try, too:
http://www.rondebruin.nl/easyfilter.htm

Troy wrote:

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?




--

Dave Peterson