Forum Discussion
feyreson
Nov 05, 2025Copper Contributor
SORTBY newb... Other solutions don't appear to apply??
Hello all! Okay, here is the situation. I have an Excel spreadsheet and each row has a dropdown that allows you to set the priority of the task. The dropdown has approximately six separate items...
feyreson
Nov 05, 2025Copper Contributor
Thank you for your reply, Sergei!
In this instance, I am trying to sort in place as opposed to pushing the data to another place. I had hoped that SortBy could accomplish this in place, but the examples (and your information here) shows me that it can't.
I just want the sheet sorted by dropdown selection in place and I want it to do it dynamically, rather than using the filter sort manually.
SergeiBaklan
Nov 06, 2025Diamond Contributor
Afraid that's VBA or Office if sort with button. If fully dynamically - VBA, but it's not clear what will be the trigger. Plus you won't have the control to sort or not to sort at this very moment.