View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Otto Moehrbach[_6_] Otto Moehrbach[_6_] is offline
external usenet poster
 
Posts: 201
Default Sorting with Drop-Down Menus

If I understand you correctly, you need to simply sort by Column G.
Whatever values are selected in each of the drop-down cells will be the
criteria used in the sort. I just tried it and it works for me. HTH
Otto
"brentm" wrote in message
...
Greetings all,

Is there a way to sort by the values selected from a drop-down menu? I
have
a spreadsheet that uses a drop-down menu in each row in column G to select
the status of the item listed in each row. I want to sort based on the
status value in each row. Any ideas?

Thanks in advance.