I would like an Excel Macro for the following scenario:
There are 200 people attending a Progressive Dinner. There are 20 cocktail hosts and 15 dinner hosts. Assign a linear number (1-200) for each of the participants. Generate a set of random numbers for each of the 200 participants with a range of 20 for the cocktail reception and with a range of 15 for the dinner. These random numbers are associated with each linear number (1-200) for the 200 participants.
Then create a set of columns for each of the cocktail hosts and dinner hosts. Under these columns, list the linear number of the participants who would be assigned to each of the cocktail and dinner hosts based upon the random number generators. I hope all of this makes sense.
If you need clarification about this whole thing, please contact me. Be sure to take NoSpam out of my e-mail address.