I learned how to create a macro button but i can't figure out the formula i need to make excel sort through a list of names and randomly pick one once you click the button. Button is on sheet 1 and the names are listed on sheet 2 in the same workbook.
Solved by S. H. in 30 mins