Randomly select 4 groups using 8 teams

I have 151 people that I need to assign to 5 different groups and then place them in 8 different teams.

Session 1 is Baseball and has 8 teams
Session 2 is Basketball and has the same people in 8 teams not in the same teams as Baseball
Session 3 is Soccer and has the same people in 8 teams not in the same teams as Baseball or Basketball
Session 4 is Football and has the same people in 8 teams not in the same teams as Baseball or Basketball or Soccer
Session 5 is Skating and has the same people in 8 teams not in the same teams as Baseball or Basketball or Soccer or Football

Is there a way to randomly assign the groups and teams in Excel?

this is a way. the macro generates 5 random lists (1-151).

Please Login or Register  to view this content.

This macro will generate 8 lists in 5 worksheets 7 of 19 and 1 of 18 members

Please Login or Register  to view this content.

best result-8 repeats
recalculate F9

This made 4 groups, but I need 8 teams within each group.

it's very complicated to devide each column in 8 teams: 1-19, 20-38 and soon.