| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Table - Calc Item Problem | Excel Worksheet Functions | |||
| Pivot Table problem | Excel Discussion (Misc queries) | |||
| Pivot Table Problem | Excel Worksheet Functions | |||
| GETPIVOTDATA - Pivot table name problem? | Excel Worksheet Functions | |||
| Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions | |||
Threaded Mode
