Dividing data in 8 equal sum colomns

[SBeaufils]

Hi I am looking for a way to help my Mom's bowling league.
She needs to divide the 64 players into a 8 teams of 6 players each. But would like that the total point (total of individual scores in each team) of every team be relatively the same.
And to make things even more challenging... 8 indevidual players are already chosen as team captains so the total score of the team must begin with their capitans score!
Can someone help me? VBA or Solver?


[TABLE="width: 204"]
<colgroup><col style="text-align: center;"><col style="text-align: center;"><col style="text-align: center;"></colgroup><tbody>[TR]
[TD="align: center"][TABLE="width: 364"]
<colgroup><col><col><col span="3"></colgroup><tbody>[TR]
[TD] [/TD]
[TD] [/TD]
[TD]AVG score[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mrs[/TD]
[TD]A[/TD]
[TD]256[/TD]
[TD][/TD]
[TD]Captain[/TD]
[/TR]
[TR]
[TD]Miss[/TD]
[TD]B[/TD]
[TD]169[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mrs[/TD]
[TD]C[/TD]
[TD]166[/TD]
[TD][/TD]
[TD]Captain[/TD]
[/TR]
[TR]
[TD]Mrs[/TD]
[TD]D[/TD]
[TD]205[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Miss[/TD]
[TD]E[/TD]
[TD]222[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mrs[/TD]
[TD]F[/TD]
[TD]235[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mrs[/TD]
[TD]G[/TD]
[TD]175[/TD]
[TD][/TD]
[TD]Captain[/TD]
[/TR]
[TR]
[TD]Mrs[/TD]
[TD]I[/TD]
[TD]180[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mrs[/TD]
[TD]J[/TD]
[TD]162[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mrs[/TD]
[TD]K[/TD]
[TD]99[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]MISS[/TD]
[TD]L[/TD]
[TD]108[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Mrs[/TD]
[TD]M[/TD]
[TD]…[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Redwolfx]

So a couple questions. You have 64 players and want to divide them into 8 groups of 6. To start, that is only 48 players... 16 of them going away? If so does it matter who is going away?