Randomly allocate players into Teams

Hi Eages, for such request, it is better you attach a sample workbook. There are several reasons for this necessity.

- We know you have a worksheet named Membership, we also know member's gender is in column E, but we have no idea where are the names, etc.
- We know you enter names manually into C8:C31 and H8:H31 of MainPage worksheet, but what are these 2 ranges? why 2 ranges of names?
- So what happens if the total number of players is not a multiple of cell O3 (No of players in a team)? Is the extra person(s) randomly assigned to teams or do they form up a last incomplete team?
- We know TeamsHistory worksheet contains the records of previous team set-ups and date, but which column is which?

Then again, this is to help helpers help you, does not guarantee you a working solution. I will try my best though.