Generate a fixture list

[kevinonearth]

Hi,
I'm trying to create a league for a tennis competition.
There are 12 players, each player plays one different player every week.
So 11 games over 11 weeks.
Does anyone have a macro that can look at a list of 12 players and produce 11 lists
where each player plays everyone else once?
Thank you!

 

[bobhc]

Good evening kevinonearth

Perhaps this will serve your purpose.

http://www.computergaga.com/blog/2011/09/excel-fixture-list-creator/

 

[kevinonearth]

Hi, thanks, yes I googled that too, but the link appears to be dead! Plus I'm hoping not to pay for it!

 

[bobhc]

Kevinonearth

I have no problem with the link? From what I have read you only pay if you need a tailored to suit spreadsheet, the one I am referring to is a free download

 

[kevinonearth]

okay thanks