I'm trying to set up a game of assassins which requires everyone on a list to be given a person to go after with a sock. There is a one to one pairing with no repeats but if i have someone they don't necessarily have me. I'm trying to make an excel spread sheet to give me a randomly generated pairings but I'm having troubles. I found a random number generator so I can generate a random number for each person that will never repeat one above it but I can't figure out how I can basically add a =A before it in the cell so that instead of a number it will reference a cell (The names are in A1-Ax). I've tried to use macros but with minimal luck. I try to make the macro by starting on the first number in the list, copying it, moving to the right one cell and then entering =A and then pasting in the value. I then move down one and end the macro. When I repeat the macro, however, instead of copying the next random number on the list it just picks the last number that I had and adds one. It doesn't make too much sense to me. I really wish that there was a way to type like =A"D1" or something where it will just insert that number right next to the =A. What is the best way of doing this? I have like 300 people to pair up and it is critical that it is random and non repeating.