I am working on a spreadsheet to keep track of football stats, as the game is going on. The info on each play is entered in a row, and each column represents different information, like who carried the ball, who threw the ball and I am trying to figure out a way to randomize who made the tackle from a list of the eleven defensive players on the field. I have tried just about everything I can think of to no avail. I need a button to push that will enter a random defender described as :DL1, DL2, DL3, LB!, LB2, etc. Any ideas would be most appreciated.