Change number of teams in fixture and league table generator

[paulj4177]

Hi all

A few years ago, someone made me this great fixture and league table generator for a competition I was running in a school I taught in. It works really well but is set for 29 teams. I need to be able to change the number of teams in it and then generate new fixtures for the extra ones plus a new league table. Is there a simple way to do this? I'm a total novice when it comes to Excel. Not sure if I copied too much. I just included the main parts and the first 2 rounds of fixtures. Thanks in advance for your help.

Maths challenge league table 24.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X
4
5						Highlight matches for		Sofia A
6
7		#	Team name	Tie-breaker option		Round	Matchup			Notes (i.e. date / location)	Score				#	Team	Pld	W	D	L	GF	GA	GD	Pts
8		1	Sofia A	1		1	Gabriel	-	Hannah			-			1	Sofia A	0	0	0	0	0	0	0	0
9		2	Valeria	2		1	Sofia V	-	Hector			-			2	Valeria	0	0	0	0	0	0	0	0
10		3	Asier	3		1	Sofia A	-	Maria V			-			3	Asier	0	0	0	0	0	0	0	0
11		4	Maria V	4		1	Natalia	-	Alfredo			-			4	Maria V	0	0	0	0	0	0	0	0
12		5	Stefany	5		1	Karin	-	Francisco			-			5	Stefany	0	0	0	0	0	0	0	0
13		6	Victoria	6		1	Camila	-	Timeo			-			6	Victoria	0	0	0	0	0	0	0	0
14		7	Camila	7		1	Darko	-	Asier			-			7	Camila	0	0	0	0	0	0	0	0
15		8	Sungkyu	8		1	Arthur	-	Victoria			-			8	Sungkyu	0	0	0	0	0	0	0	0
16		9	Claudia	9		1	Claudia	-	Stefany			-			9	Claudia	0	0	0	0	0	0	0	0
17		10	Hector	10		1	Jamie	-	Victor			-			10	Hector	0	0	0	0	0	0	0	0
18		11	Sofia V	11		1	Valeria	-	Sungkyu			-			11	Sofia V	0	0	0	0	0	0	0	0
19		12	Gabriel	12		1	Arianne	-	Mia			-			12	Gabriel	0	0	0	0	0	0	0	0
20		13	Victor	13											13	Victor	0	0	0	0	0	0	0	0
21		14	Darko	14		2	Gabriel	-	Claudia			-			14	Darko	0	0	0	0	0	0	0	0
22		15	Jamie	15		2	Jamie	-	Arthur			-			15	Jamie	0	0	0	0	0	0	0	0
23		16	Karin	16		2	Valeria	-	Darko			-			16	Karin	0	0	0	0	0	0	0	0
24		17	Natalia	17		2	Arianne	-	Camila			-			17	Natalia	0	0	0	0	0	0	0	0
25		18	Mia	18		2	Mia	-	Karin			-			18	Mia	0	0	0	0	0	0	0	0
26		19	Alfredo	19		2	Sungkyu	-	Natalia			-			19	Alfredo	0	0	0	0	0	0	0	0
27		20	Arthur	20		2	Victor	-	Sofia A			-			20	Arthur	0	0	0	0	0	0	0	0
28		21	Francisco	21		2	Stefany	-	Sofia V			-			21	Francisco	0	0	0	0	0	0	0	0
29		22	Timeo	22		2	Victoria	-	Hannah			-			22	Timeo	0	0	0	0	0	0	0	0
30		23	Arianne	23		2	Asier	-	Hector			-			23	Arianne	0	0	0	0	0	0	0	0
31		24	Hannah	24		2	Timeo	-	Maria V			-			24	Hannah	0	0	0	0	0	0	0	0
32						2	Francisco	-	Alfredo			-
24teams

Cell Formulas
Range	Formula
P8:X31	P8	=IFERROR(INDEX($AN$7:$BC$31,MATCH($O8,$BC$7:$BC$31,0),MATCH(P$7,$AN$7:$BC$7,0)),"")
G8,G21	G8	=player_12
G9,I28	G9	=player_11
G10,I27	G10	=player_1
G11,I26	G11	=player_17
G12,I25	G12	=player_16
G13,I24	G13	=player_7
G14,I23	G14	=player_14
G15,I22	G15	=player_20
G16,I21	G16	=player_9
G17,G22	G17	=player_15
G18,G23	G18	=player_2
G19,G24	G19	=player_23
I8,I29	I8	=player_24
I9,I30	I9	=player_10
I10,I31	I10	=player_4
I11,I32	I11	=player_19
I12,G32	I12	=player_21
I13,G31	I13	=player_22
I14,G30	I14	=player_3
I15,G29	I15	=player_6
I16,G28	I16	=player_5
I17,G27	I17	=player_13
I18,G26	I18	=player_8
I19,G25	I19	=player_18

Named Ranges
Name	Refers To	Cells
'24teams'!player_1	='24teams'!$C$8	I27, G10
'24teams'!player_10	='24teams'!$C$17	I30, I9
'24teams'!player_11	='24teams'!$C$18	I28, G9
'24teams'!player_12	='24teams'!$C$19	G21, G8
'24teams'!player_13	='24teams'!$C$20	I17, G27
'24teams'!player_14	='24teams'!$C$21	I23, G14
'24teams'!player_15	='24teams'!$C$22	G22, G17
'24teams'!player_16	='24teams'!$C$23	I25, G12
'24teams'!player_17	='24teams'!$C$24	I26, G11
'24teams'!player_18	='24teams'!$C$25	I19, G25
'24teams'!player_19	='24teams'!$C$26	I32, I11
'24teams'!player_2	='24teams'!$C$9	G23, G18
'24teams'!player_20	='24teams'!$C$27	I22, G15
player_21	='24teams'!$C$28	I12, G32
player_22	='24teams'!$C$29	I13, G31
player_23	='24teams'!$C$30	G24, G19
player_24	='24teams'!$C$31	I29, I8
'24teams'!player_3	='24teams'!$C$10	I14, G30
'24teams'!player_4	='24teams'!$C$11	I31, I10
'24teams'!player_5	='24teams'!$C$12	I16, G28
'24teams'!player_6	='24teams'!$C$13	I15, G29
'24teams'!player_7	='24teams'!$C$14	I24, G13
'24teams'!player_8	='24teams'!$C$15	I18, G26
'24teams'!player_9	='24teams'!$C$16	I21, G16

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
O8:X31	Expression	=$P8=$H$5	text	NO
F9:M604	Expression	=$AA9=1	text	NO
F8:M8	Expression	=$AA8=1	text	NO

Cells with Data Validation
Cell	Allow	Criteria
H5:I5	List	=$C$8:$C$31

 

[bebo021999]

Is VBA macro acceptable?

 

[paulj4177]

Is VBA macro acceptable?

Hi bebo

I'm really sorry but I don't actually know what that means I'm a very basic excel user.

 

[bebo021999]

Formula base is what in your file
VBA base is apply macro that written in VBA window, hidden running and paste value or format in sheet only.
What is the logic in your program?
For instant, there are 4 teams A,B,C,D. what the outcome look like? How many matchs?

 

[paulj4177]

Ideally I'd be able to change the number of teams reasonably easily so I could use it each year depending on the size of my class. I just want them to play each other once.

 

[bebo021999]

Is there a case:
Gabriel - Hanna
Hanna - Gabriel
?

As request from #4, how is the results of 4 teams look like?