Hi,

I am in charge of running and organizing golf tournaments and I was wondering if someone could help me figure out how to make my life easier with excel. The main thing that I have to do is create the Tournament Draw and Alpha list based on a list of names.

I have attached a file below and I was wondering how I can easily get all the names from the player list into the Draw list but at random. So all these names would be mixed up in groups of four.

Once that is complete I need all these names sorted on an Alpha list by last name and also include what group they are in.

I'm sure there is an easier way of doing this without just copying and pasting.

Practice Tournament Draw.xlsx

Thanks.