Auto-Sort Areas

New Contributor

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



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.



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.



Additional Informations:


Sort data in a table

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!