Seems I have totally screwed up in explaining what I am trying to do.
I have a yearly tournament that has anywhere from 36 upwards to 50 players. The regular 3 day tournament is a 2 man team where the same 2 players play together all 3 days.
I am trying to add a 'side' tournament where each player would be paired with a different partner each of the 3 days and of course, separate scoring method for that side tournament.
So, hopefully I can get it right this time.
example - Players 1 and 2 are partners for all 3 days for the main tournament.
Also in the side tournament, player 1 would be paired with one of the other, in this instance, 38 players for the first day, 1 of the 37 players the second day, and one of the 36 players the third day.
So he would never be paired with his normal partner in the side tournament and would never have the same partner any two days.
I would assume in your code, if the total number of players changed to, say, 46, I would need to change the "for j = 1 to 40" statement to 1 to 46 ?
Also is there a way to add a button to run the macro ?
Thank you so much and I humbly apologize for not explaining it all.