Hi all,
What i'm looking to do is create a spreadsheet where the first page allows me to input the number of teams in the group.
The teams cannot play others in the group except the ones they are paired with.
eg. "Enter number of team pairs in set" (in this case 4)
Team 1a vs Team 1b
Team 2a vs Team 2b
Team 3a vs Team 3b
Team 4a vs Team 4b

After number of teams in set is established click a start button on the first tab of the spreadsheet.

this auto generates a new tab with all the possible win/loss combinations of 4 team pairs.
New Picture.jpg


if the number of teams on Tab 1 is changed (say to 6) and the start button is clicked, another new tab is generated with all possible win loss combinations of a 6 team set.

Is this possible? and how easy would it be?
remember 1a vs 1b can only be win or lose
and the win lose combinations are for the set of 4 matches ( or more matches if specified on the first tab and clicked).
if you put 7 in for the number of team pairs then it would be win loss combos for 7 pairs of teams.
Thank you in advance.
mrhempNew Picture.jpg