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.

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.