I've attached a manual solution to the problem.
To achieve this, I took the teams from the left side of Round 1 and copied them into the left side of Round2, but shifted down by 1 event (Team 13 thus "wraps" into event 1). The teams on the right hand side of Round1 get copied into the right hand side of Round2, but moved down by 2 events (and thus Teams 12 and 14 appear at the top in this round. The same procedure is used for all the other rounds, i.e. the left-hand teams are moved down by 1 event and the right-hand teams are moved down by 2 events (it works because you have an odd number of events).
I feel that I should be able to put a formula in D3 and E3 based on an INDEX of B and C respectively, but which moves the indexed cell by 1 and 2 respectively, wrapping to bring 7 and 6/7 to the top, and then those two columns can be copied across, but as it's getting late here I can't concentrate - perhaps someone else will chip with a solution to this algorithm in while I get some sleep.
Hope this helps.
Pete
Bookmarks