ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Sorting with Drop-Down Menus (https://www.excelbanter.com/excel-programming/310810-re-sorting-drop-down-menus.html)

Otto Moehrbach[_6_]

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.




brentm

Sorting with Drop-Down Menus
 
I tried to sort simply by column G, but it didn't work. There is not any
data actually in the cells in column G. the drop-down boxes are simply on
top of the cells in column G for aesthetic purposes. Any other ideas?

"Otto Moehrbach" wrote:

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.






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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com