So just to start I have looked online and I can see lots of examples but I just cant seem to get what I want to work.
Hopefully it is easy, what I want to do is draw a random name from a list in column A, I would like the first name to go into b1 then draw another random name and add that to cell c1, third in b2 fourth in c2 so on and so forth, Every time a name is drawn I want it removed from the original list so it cant be drawn again, I want this to happen until there are no names left in the original list in column A.
Appreciate any help
Bookmarks