A pivot table is good for summarizing numerical data, so it may not be
what you need.

You could use a filtered list to display the relevant data. There are
instructions for AutoFilters in Excel's Help, and he

http://www.contextures.com/xlautofilter01.html

HRDataFool wrote:
I am putting together a form that will be used throughout our organization.
There are specific jobs linked to specific departments. How can a display a
list of only those jobs associated with the department number that is keyed
in? This is a big organization and managers are not going to want to scroll
through every job we have just to find the ones in their department. Help is
appreciated.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html