i run a six a side football club at work and each week i pick the team and
people moan.

is there a way in excel vba to put 'name in a hat' and generate my teams?

using player 1 - 12 as an example?

thanks in advance...