Need a random matchup of partners for a card league???

[motox614]

I am in a card league with 24 people, everyone gets a partner and plays 2 other people that are partners at one of 6 differnt tables. I am trying to create an excel formula or vb marco that will allow for a randomly selected partner and match up against 2 other randomly selected partners at one of the 6 random tables. So when it done there will be 6 tables with 2 pairs of partners for a total of 24 people. Any help in the right direction would be greatly apperciated. Thanks

[6StringJazzer]

Here is one simple option. This sheet has a list of 6 tables, with two parings at each table. It has a list of people's names with a random number labelled "Sort Order". If you click on the dropdown on the Sort Order header, and select Sort Smallest to Largest, it will sort the names in random order and refresh the random numbers.

Let me know if this fits the bill. A more elegant solution could be done with a macro so you that you don't see the random numbers.