| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Need help with Drop-Down list and Pivot Table
In excel, I can make a drop list for a cell so that users can choose the
correct item but of course they cannot manually type in an entry if they needed too. Can you make it where they can choose an item from the drop-down list or also be able to type in their own entry? Thanks |
|
#2
|
|||
|
|||
|
What kind of dropdown list are you using, and how is it connected to the
pivot table that you mentioned in the subject line? Jared_Hmr wrote: In excel, I can make a drop list for a cell so that users can choose the correct item but of course they cannot manually type in an entry if they needed too. Can you make it where they can choose an item from the drop-down list or also be able to type in their own entry? Thanks -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
| Pivot Table services | Excel Discussion (Misc queries) | |||
| maximum size of a Microsoft Excel list for a pivot table | Excel Discussion (Misc queries) | |||
| convert excel list to pivot table | Excel Discussion (Misc queries) | |||
| How do I use multiple worksheets (List) in a Pivot Table Report? | Excel Worksheet Functions | |||
Linear Mode
