Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I email amacro? | Excel Worksheet Functions | |||
MACRO QUESTION | Excel Worksheet Functions | |||
Macro Question | Excel Worksheet Functions | |||
Excel Macro Question | Excel Worksheet Functions | |||
using a macro question revisited | Excel Discussion (Misc queries) |