Sorting multiple ranges

[zeleni]

Hi!

I have a problem, which my imagination can't solve

A week from now we're going to have a (air rifle) shooting competition in our town. 3 random members of each club which have been registered are in teams.
Competition is quite simple, individuals shoot 20 rounds, the rounds are counted and written in an excel workbook, a simple macro here and a sum function solve the problem.

In teams, the story is different. We sum the score of 3 members together and this sum becomes the base on which we decide.
On the scoreboard, every name, his individual score, team sum and team name has to be displayed.

Here is the problem, I have 25 teams which have to be sorted by the team sum in descending order, but I don't know how, because there are 25 ranges of data.

My knowledge of VBA is at a beginner level; if anyone could help (or a give me a clue) me it would be great.

--------

A way that I think about the problem: (as I would do it in VBA)
Selecting the range of cells, which become a group, 25 times that way, selecting every group as a separate variable and sorting them by the one cell (team sum). Just need help with the code.

If anyone is interested i can upload the xls(m) file.

Thank you very much.

[walruseggman]

Please upload the file.

[zeleni]

http://www.filedropper.com/upokojenci1992014

The above described problem is on the 4th worksheet called "ekipe".

[zeleni]

Maybe have any clue?
I am 100% sure that I have seen a button in Excel doing the same thing (same purpose), the thing is I don't remember where.