Auto sort values from highest to lowest based off of value

Thank you for the response but that's not exactly what I need done. I need it to auto sort whenever the values are changed so that I don't have to do it manually each time I put in numbers.

See the attached example.
On Sheet1, the marked column of data gets sorted in ascending order every time you add another value in that range or delete or change a value.
Hope it helps.
Expand the range as you need in the Macro.
modytrane

Here's your file.
I had to create column A with copies of pct and sort all five column.
If you change any value for any sales rep.i Nashua, that block will automatically sort.
Hope it helps.
modytrane.

That is exactly what I want it to do thank you! But how do I do it for the other 3 blocks of info?

Originally Posted by qj67

That is exactly what I want it to do thank you! But how do I do it for the other 3 blocks of info?

This is exactly what I'm looking for. How can I apply this to my worksheet? I don't see how it has been done! LOL

Take a look at the attached file. This does what you wanted.
Have Fun,
modytrane