Forum Discussion
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...
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.
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.