Hello -
I am creating a basic model for a manager in which I need to select, at random, winners for three different levels of prizes (Level 1 - 10 winners, Level 2 - 22 winners, and Level 3 - 44 winners).
On Sheet1, I have built the framework for the with three sections (one for each prize) including the spots where I would need the winners name to appear along with potential macro spot. On sheet2 I have the names of all eligible winners in A1:A76.
The goal is to create a function that will give the user the ability to press the "button" on sheet one which then pull, at random, from the list on sheet2 and pull the results into a desired cell on sheet1. Thereotetically, we would want to have the ability to press the button 10 times for the first prizes, 22 times for the second, and so on...
I would prefer to not assign the contestants random numbers using the rand or randbetween function. Rather, we are trying to create what, if any, suspense possible by having their names appear on the dashboard.
I really appreciate any possible guidance or thoughts to my process. Please don't hesitate to follow up with questions!
Thanks,
Scott
Bookmarks