A tough macro question
24 players 6 tables 4 players at a table What I would like to do is have a macro generate a list of who sits at what table for each round. The kicker is that once you played with or against someone - you should not see them for the rest of the night. The minimum number of rounds for this condition would be eight. I believe that I will need nested for statements For i = 1 to 6 for the table For j = 1 to 4 for the players - but not sure how to check to see if an individual has already played against someone. any thoughts |
All times are GMT +1. The time now is 01:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com