Arrange Items In Table?

Im developing one excel vba file to an entity .

My main objective is speed and automatization in the competition organization.

Im almost finishing it but now im stuck in this situation:

I have a table with 13 cells

A: athlete name
B: athlete weight
C: random number (raffle)
and then from 1 to 10 is the final Groups.

E.g

Name
Weight
No
1
2
3
4
5
6
7

[code].....

Now i need to create a macro to display the itens in the groups when the weighing is finished...

E.g

Name
Weight
No
1
2
3
4
5
6
7
8
9

[code].....

The conditions are:

The numbers should be displayed in the athletes groups

The difference between all the athletes weights shouldn't be > 3 kilos If theres is more than 5 athletes per group the heaviest should go to next athletes group and pop up one message informing that maximum athletes per group was reached...