B bfraser Member Nov 22, 2010 #1 For the holidays I'd like to create a worksheet that has a command buttons that when clicked, randomly generates a name from a list (A1:A17) and removes that name from the list to avoid duplicates.
For the holidays I'd like to create a worksheet that has a command buttons that when clicked, randomly generates a name from a list (A1:A17) and removes that name from the list to avoid duplicates.
X xld Member Nov 22, 2010 #2 Try this http://www.mediafire.com/file/4chl1cyqn7x3esg/Chandoo%20-%20Secret%20Santa.xlsm