software

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

I use xl2003 and just tried setting up a worksheet. The dropdown list (used in
the Data|filter|autofilter) was sorted no matter what I did.

Ahhh.

Maybe....

Is your data numeric?

Maybe your data is a combination of Text ('123 or the cell preformatted as Text)
and real numbers???
Kylor wrote:
gt;
gt; We have a spreadsheet that information is always being added to by one group
gt; and the agents of another just use the filter feature to find information.
gt; When new information is added to the sheet the list of options in the filter
gt; are not sorted. How do we get new information added to the sheet to appear
gt; in the filter's drop down list in sorted order? Right now, the new data
gt; appears at the top of the list of options in the drop down list instead of
gt; being sorted in with the existing list of options. Thanks!
gt;
gt; K

--

Dave Peterson

ps. If you do have a combination of number numbers and text numbers, the
solution is to settle on one version and use that.

Dave Peterson wrote:
gt;
gt; I use xl2003 and just tried setting up a worksheet. The dropdown list (used in
gt; the Data|filter|autofilter) was sorted no matter what I did.
gt;
gt; Ahhh.
gt;
gt; Maybe....
gt;
gt; Is your data numeric?
gt;
gt; Maybe your data is a combination of Text ('123 or the cell preformatted as Text)
gt; and real numbers???
gt;
gt; Kylor wrote:
gt; gt;
gt; gt; We have a spreadsheet that information is always being added to by one group
gt; gt; and the agents of another just use the filter feature to find information.
gt; gt; When new information is added to the sheet the list of options in the filter
gt; gt; are not sorted. How do we get new information added to the sheet to appear
gt; gt; in the filter's drop down list in sorted order? Right now, the new data
gt; gt; appears at the top of the list of options in the drop down list instead of
gt; gt; being sorted in with the existing list of options. Thanks!
gt; gt;
gt; gt; K
gt;
gt; --
gt;
gt; Dave Peterson

--

Dave Peterson

I bet that is the answer, the formatting of the new text is probably
different from the original information. I'll check it out. Thanks!

quot;Dave Petersonquot; wrote:

gt; I use xl2003 and just tried setting up a worksheet. The dropdown list (used in
gt; the Data|filter|autofilter) was sorted no matter what I did.
gt;
gt; Ahhh.
gt;
gt; Maybe....
gt;
gt; Is your data numeric?
gt;
gt; Maybe your data is a combination of Text ('123 or the cell preformatted as Text)
gt; and real numbers???
gt;
gt;
gt;
gt; Kylor wrote:
gt; gt;
gt; gt; We have a spreadsheet that information is always being added to by one group
gt; gt; and the agents of another just use the filter feature to find information.
gt; gt; When new information is added to the sheet the list of options in the filter
gt; gt; are not sorted. How do we get new information added to the sheet to appear
gt; gt; in the filter's drop down list in sorted order? Right now, the new data
gt; gt; appears at the top of the list of options in the drop down list instead of
gt; gt; being sorted in with the existing list of options. Thanks!
gt; gt;
gt; gt; K
gt;
gt; --
gt;
gt; Dave Peterson
gt;