List all combinations of players for matches

[plsm5882]

Hi.

I have a list of players in C5:C14. Not all cells in that range will always have a player name in it.

In C16:D110 I'd would like to build the match linups.

For example, on Sheet2, Sheet3, Sheet4 and Sheet5:

C1: Player 1
C2: Player 2
C3: Player 3
C4: Player 4

C16: Player 1 D16: Player 2
C17: Player 3 D17: Player 4
C18: Player 1 D17: Player 3
C19: Player 2 D19: Player 4
C20: Player 1 D20: Player 4
C21: Player 2 D21: Player 3

It should run this code whenever anything changes in column 6 on Sheet6.

Is anyone able to please help me out as I am a complete VBA newbie.

Thanks

 

[plsm5882]

There aren't necessarily an even number of players in a group, and the maximum number of players in each group is 10.

 

[svendiamond]

This is a bit of a challenge as it's not just a VBA or Excel problem, but more like a math or creativity problem. Tell me, what would your expected results be for a group of five players?

 

[plsm5882]

Actually, the code you have done is fine. It doesn't matter that the order is not "playable" as such. Thank you very much for your help.