Create a dynamic football tournament event macro

MrPink1986

Active Member
Joined
May 1, 2012
Messages
250
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 AGROUP BGROUP CGROUP D
Team nameTeam nameTeam nameTeam name
Team ATeam ETeam ITeam M
Team BTeam FTeam JTeam n
Team CTeam GTeam KTeam O
Team DTeam HTeam LTeam P
Group APitchKickoff TimeGroup BPitchKickoff TimeGroup CPitchKickoff TimeGroup DPitchKickoff Time
Team ATeam BA17:30Team ETeam FB17:30Team ITeam JC17:30Team MTeam nD17:30
Team BTeam CA17:45Team FTeam GB17:45Team JTeam KC17:45Team nTeam OD17:45
Team ATeam DA18:00Team ETeam HB18:00Team ITeam LC18:00Team MTeam PD18:00
Team CTeam AA18:15Team GTeam EB18:15Team KTeam IC18:15Team OTeam MD18:15
Team DTeam CA18:30Team HTeam GB18:30Team LTeam KC18:30Team PTeam OD18:30
Team BTeam DA18:45Team FTeam HB18:45Team JTeam LC18:45Team nTeam PD18:45

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Watch MrExcel Video

Forum statistics

Threads
1,108,706
Messages
5,524,418
Members
409,577
Latest member
Dwg

This Week's Hot Topics

Top