Create a dynamic football tournament event macro

MrPink1986 · Mar 19, 2019

Hi there,

I would like to create a macro that would save me so much time and also be fully correct as my current approach is quite manual.
Let me describe what I require:

Inputs;
Team Name- this will list the teams taking part - this will range from 1-16
Number of Groups - this will be range from 1-4
No of teams in the group - this will range from 3-5

Logic;
The number of teams in the group in the number of groups will come from the Team name and list and will only contain unique values.

Inputs;
Number of Pitches - 2-4
Event start Time - time value xx:xx
Length of each game - variable 5-15 mins

Logic;
The macro should create start times for each game and assign each game a pitch number. There should only be one game at each time with that team involved. Once the first game is completed the macro should be able to list the next kick off time - the first game will conclude when the Event start Time + Length of each game + 3 mins elapses.

Below is the final output

GROUP A

GROUP B

GROUP C

GROUP D

Team name

Team A

Team E

Team I

Team M

Team B

Team F

Team J

Team n

Team C

Team G

Team K

Team O

Team D

Team H

Team L

Team P

Group A

Pitch

Kickoff Time

Group B

Pitch

Kickoff Time

Group C

Pitch

Kickoff Time

Group D

Pitch

Kickoff Time

Team A

Team B

A