VBA automatically sort by rank when data change

[kirana2014]

Hello, firstly many thanks for taking the time to look at my problem.
How to sort the data automatically by rank when data is change
so i have included an example spreadsheet as well as an example.

Any help or comments would be greatly appreciated.

Many thanks

Kirana Wayan

[Bo_Ry]

Please try

Please Login or Register  to view this content.

[kirana2014]

Dear Bo_Ry,

Is working thank for your help.