![]() |
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. |
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