I went ahead with the next step.
I filled out ‘Schedule-per-team’ in order to make ‘1 team sheet’ work.
I changed the reference in B1 from Team 1 to 1 team, 2 team, 3 team, etc. so that they would match the Table1 row headers.
Rather than make 32 separate sheets I put enough # team sections in one sheet to make certain it would work for the offsetting “Rests” in Table1 (which begin with 17 team).
For 1 team array enter this formula (Ctrl + Shift + Enter) into B2. Fill down to B10. Then in C2:C10 this non-array formula. Copy this range including the numbers in column A and paste below each heading of # teams. (You’ll need to change the row references for teams in the new rows below.)
Now when you change data in ‘Schedule-per-activity’ the other sheets will update accordingly.
I find no data for points or rankings so I am not able to do the last step in sheet ‘Football’.
Please see the attached.
Bookmarks