how do I create a football team syndicate?

[Needing Help!!]

I want to create a team syndicate for 8 teams and set it up so that I just
key in the team names and it works out itself who plays who in the next round
and whether they play home or away. Is it possible?

 

[Bernie Deitrick]

No. An easy way to do this is to get the schedule from an eight team league (like Australian A
league) and copy their schedule, then do find and replace...

http://www.a-league.com.au/default.aspx?s=fixtureresults&seasonid=18&roundid=-2

Of course, they play 21 rounds - you could copy just the first seven, or the first fourteen....

HTH,
Bernie
MS Excel MVP