Auto-Sort Areas

[mcwinters19]

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?

[#2]

@mcwinters19 

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.

[#3]

@NikolinoDE 

Additional Informations:

Sort data in a table

[#4]

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