Every year my company hosts a golf outing which consists of random teams. I have had a spreadsheet set up ranking people from best to worst. I then take each quarter, and assign them as A, B, C or D player.

I then randomly put an A B C and D player together to form a team. Historically, I've just run some kind of random number generator in asp.net, then copy/pasting the results next to the player, then sorting.

What I'd like to do is have some kind of button and automatically post teams on another sheet.

How would I get started with this?