League table fixture creator.

[Wazeem]

Hi All,

Please, can anyone help me build a fixture creator for a league that I'm participating?
Here is the setup

14 teams play each other.(There would be 91 games in total, correct me if I'm wrong)
Each week there should be two games for one team.
All the fixtures should randomly be picked.


Thanks for your help.

 

[NdNoviceHlp]

Not sure what a fixture creator is? I suspect it's something like this...

https://www.mrexcel.com/forum/excel-questions/1038895-round-robin.html
HTH. Dave

 

[Wazeem]

Not sure what a fixture creator is? I suspect it's something like this...

https://www.mrexcel.com/forum/excel-questions/1038895-round-robin.html
HTH. Dave

Hey, Dave thanks for the reply, I'm Not that excel savvy, can you please explain how do use these codings?

 

[NdNoviceHlp]

"Place player/teams in Column A starting at A1. Place code in sheet 1 code"
Alt+F11 to open VBE and place code in sheet1. Now U can call or run the sub. Go to view macros and select the roundrobin sub to run... OR... place an active X command button on sheet 1. Right click on it to view code. Place this in the code.

 Call RoundRobin

...then select the button to run the macro. HTH. Dave

 

[Wazeem]

Thanks for your help, sounds very complicated. can you please recommend some materials where I can learn basic's of Macro.. I tied your instruction, I got lost after 1st sentence.. lolzz

 

[NdNoviceHlp]

It's not complicated to use a macro. Copy the code above into a macro enabled workbook. Press alt-F11 at the same time. Paste. Return to sheet view. Select view. Select macro. Select roundrobin. Select run. That's it. After instal, just run the macro. Dave

 

[Wazeem]

Dude it work's,, Thanks.. I think going to spend lots of time learning this Macro. Sound interesting

 

[Wazeem]

How can I create a button or a shortcut key to refresh the table each time I hit??

 

[NdNoviceHlp]

Please see post #4 of this thread following "...OR..."
Dave

 

[Wazeem]

HEY think there is a problem with the coding, I have 14 teams playing each other, which means 1 team should get 13 games but when run the Macro some teams get less games. can please fix this..

Thanks

dave,,