automatically sort row

which row do you want to sort? where do you want to put the answer? have you looked into using the =larger() function?

you could create you're own macro for this using "record" mode. Then add a button to apply the macro.

Practice what you want to do a few times, then plress the "record" button on the bottom left of the screen, next to the "ready" icon. with that selected, every action you do is recorded and can then be used again later on command

I need code automatically sort row when data when change data in cell H