VBA to create 2 teams by Skill and Position

[tsr123]

Hi I am looking to create a random team generator by 2 variables, skill and position.

Was either thinking like the below and then some VBA to split into two teams and ensuring the positions are as evenly split as poss, i.e. in the case there may be more DEF than ATT

Player Rating Position
Player1 5 GK
Player2 9 DEF
Player3 7 ATT
Player4 6 DEF
Player5 5 ATT
Player6 7 GK
Player7 3 DEF
Player8 7 ATT
Player9 8 DEF
Player10 6 ATT
Player11 8 ATT
Player12 5 DEF
Player13 6 ATT
Player14 7 DEF

Or

An Attack and Defense Rating but flagging two as GK's to ensure they are on two different teams

Player Attack Rating Defense Rating GK
Player1 5 8 x
Player2 9 6 x
Player3 7 8
Player4 6 5
Player5 5 6
Player6 7 7
Player7 3 5
Player8 7 9
Player9 8 7
Player10 6 6
Player11 8 5
Player12 5 7
Player13 6 3
Player14 7 7


Any ideas would be massively appreciated

[Bernie Deitrick]

VBA is not really needed for this.

Sort by Position, then by skill. For the Keepers, use Team B, then Team A For the Attackers, use A B B A and repeat for however many players you have - and for the defenders, use B A A B and repeat. This will pair the 1st and 4th most skilled, and the 2nd with the 3rd, attackers; paired with the 2nd with the 3rd, and the 1st and 4th most skilled defenders.