Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kylor
 
Posts: n/a
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default re-ordering the list on a filter drop down

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:

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


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default re-ordering the list on a filter drop down

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:

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:

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


--

Dave Peterson


--

Dave Peterson
  #4   Report Post  
Posted to microsoft.public.excel.misc
Kylor
 
Posts: n/a
Default re-ordering the list on a filter drop down

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!

"Dave Peterson" wrote:

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:

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


--

Dave Peterson

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I make other cells dependent on my drop down list? mae1778 Excel Discussion (Misc queries) 1 July 29th 05 04:25 PM
Data Validation using List (But needs unique list in drop down lis Tan New Users to Excel 1 July 8th 05 03:32 PM
changing value of a cell by selecting an item from a drop down list Bobby Mir Excel Worksheet Functions 6 June 8th 05 08:33 PM
drop down list multiple columns c Excel Discussion (Misc queries) 9 January 27th 05 04:13 PM
automatic color change in cells using a drop down list kennethwt Excel Worksheet Functions 1 January 21st 05 07:37 PM


All times are GMT +1. The time now is 10:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"