I am doing a cow patty drop for my local non-profit community group. We are selling tickets (numbered 101-676) for the event. In order to show who's name ends up where in the tennis court that will be marked in a 24 x 24 grid, I would like to show each ticket number (or preferably the corresponding name) in each square of the grid. I listed the ticket numbers in column A, the names in column B, and the phone number in column C (which will be only be used to call the winner). I made a 24 x 24 grid next to the data. I have attempted a few different ways - using randbetween(), rand(), and rank() but haven't figured it out yet. I don't want repeats (unless the person bought more than one ticket of course). I would also like to put a button the screen to initiate the random number generator and then have the names pop up in the screen. I don't want the locations to change on the grid when I add a name - chances are we will be selling tickets until the very end. I figure that I need to write a program in VBA utilizing the randbetween and match - or Vlookup function. Would someone please help me? Thanks in advance!