| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
re-ordering the list on a filter drop down
We have a spreadsheet that information is always being added to by one group
and the agents of another just use the filter feature to find information. When new information is added to the sheet the list of options in the filter are not sorted. How do we get new information added to the sheet to appear in the filter's drop down list in sorted order? Right now, the new data appears at the top of the list of options in the drop down list instead of being sorted in with the existing list of options. Thanks! K |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make other cells dependent on my drop down list? | Excel Discussion (Misc queries) | |||
| Data Validation using List (But needs unique list in drop down lis | New Users to Excel | |||
| changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
| drop down list multiple columns | Excel Discussion (Misc queries) | |||
| automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
Threaded Mode
