Forum Discussion
Auto-Sort Areas
I have multiple areas which I would like to sort based on their column value "Rankings". Every time a change to the rankings is made I have to manually re-sort each area. Is there a way to make a gro...
To automatically re-sort you'll have to try a macro, excel doesn't have this feature built into it (outside of manually updating and sorting by hand). It's not too complicated to get running, I found a link that shows step by step how to auto-sort data:
This explains what you're looking for better than I could!
https://www.excelhow.net/how-to-sort-data-automatically-in-excel-new-data-is-entered-or-data-changed.html
This explains what you're looking for better than I could!
https://www.excelhow.net/how-to-sort-data-automatically-in-excel-new-data-is-entered-or-data-changed.html