Auto Sort macro

Hello guys,

No matter how many times I try to do it myself, I keep failing. So please, can anyone do this for me:

1.) SOCCER
image.png

A: Teams
B: Matches Played
C: Wins
D: Draws
E: Losses
F: Goals Scored
G: Goals Conceded
H: Points
I: Goal difference

Columns B, H and I are calculated automaticaly by simple formulas, when I change cell values for columns C, D, E, F and G. I just need to auto sort all this, first descending by column H (points) and then descending by column I (goal difference). Can anyone write down the macro code for me?


2.) BASKETBALL
image.png

A: Teams
B: Wins
C: Losses
D: Winning Percentage

Column D is calculated automaticaly when I input and cnange cell values of B and C columns. I just need to auto sort this, first descending by column D (winning percentage) and then descending by column B (wins). Can anyone write down this macro code for me as well, please?

Both tables (sheets) look exactly as pictured above...

I'm desperate with this...

Thanks in advance!

Jasmin

Soccer:

Please Login or Register  to view this content.

Basketball:

Please Login or Register  to view this content.

Thanks, yudlugar, but I need the full code, I'm a beginner...

Soccer:

Please Login or Register  to view this content.

Basketball:

Please Login or Register  to view this content.