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

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

@NikolinoDE 

 

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!
https://www.excelhow.net/how-to-sort-data-automatically-in-excel-new-data-is-entered-or-data-changed...