How to realize dynamic sorting

[302]

The file I uploaded is the code written by beyond excel. Now I have a new need for work. I hope someone can help me.
In the source data table, click the click button and the data will be automatically extracted to the convert array table.
How can I calculate the total score of each row in the convert array table, and then dynamically add it to the last column of the row,
and then sort it according to the total score from the highest to the lowest?
thanks a lot.

[beyond Excel]

How can I calculate the total score of each row in the convert array table...

Hello @302: I see that you are adding details little by little!...
The ordering thing is the least important because it is done at the end and it is simple.

Now:
Could you upload your workbook to the Forum but enter by hand the formulas you use to calculate the total score?

[302]

Sir, I will do this manually.
But I want to learn more about vba, just like the code you provide. I can't understand how your code is implemented. It's too difficult.
It would be better if you could explain it.
I also want to improve my vba ability.
So I raised this requirement.
I don't know how to use VBA to realize the whole process of office automation, and I don't know where to start with advanced VBA programming.