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