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 group of cells automatically sort by a column value?
3 Replies
- 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 Here is a small example with sorting.
Simple and effective :)).
Look at the filter in the inserted file.
Simply sort the column area as desired.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
