Generate automatically double

Hi everyone,

I'm creating a spreadsheet on which I need to draw a pair.
Basically I have two groups of people. And when I click on the button, I need to pair people from Group 1 with people from Group 2.
And so on until all of group 1 compete with all of group 2. If possible, one draw at a time.

teste.PNG

I tested some options to generate random draws, but I couldn't implement it for my case.

Could someone help me in this case?

Grateful in advance

Perfect. Thank you very much!

A doubt:
What would the code look like if I have a column with more members than another column?
Example: Group 1 with 10 members and Group 2 with 15 members.
In his code, he perform dulas with blank cells.

This CommandButton Click event code assumes no gaps in the data in Columns A and C, that Columns A, C and G:H have header text already in them. This code will output a single non-repeated pairing with each press of the CommandButton. To do a new pairing, simply delete the data from cells G2:H2 down to the end of the data in those columns... once you have done that, a new set of pairings will be generated the next time the CommandButton is pressed.

Please Login or Register  to view this content.

Perfect!
Thank you very much everyone for your help.