here goes
randomize either name to team or team to name
list of football teams 40
list of names 40
command button 1
press command button so that a name will match up to a team , but never
duplicate until reset, use the a1:a40 cells and b1:b40 cells

hope i have made it clear for all you people
good luck and many thanks

example

A B
1 bob billingham
2 dave hartlepool
3 john redcar

after click on command button to randomize team or name

A B
1 bob hartlepool
2 dave redcar
3 john billingham