Titles

[Troy]

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?

 

[Bob Umlas]

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]

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.

 

[Shailesh Shah]

Hi Troy,

In case you want utility, you can download "Workbook Navigation" add-ins
from the add-ins page of below site.
http://in.geocities.com/shahshaileshs/

You should also give your database range name as "Database".
1.Select the cell value to extract the records (in your case 'Line Tec') .
2.Load the addins dialogbox from the addins toolbar (top one). (See the
Dialogbox Image in the website)
3.Right click on the Data Entry button, Select option Extract selected
records of .<name>... .
This will extract records to a new sheet named with the selected cell
value.

Any problem e-mail me.

Regards,
Shailesh Shah
http://in.geocities.com/shahshaileshs/
(Excel Add-ins Page)

---------------------------------------------------------------------

 

[Dave Peterson]

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