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