Hi.
I have a drop down box using data validation, and I'm currently designing staff rosters. I want to be able to let Excel randomly select a value in the drop down box.
Eg.
If i have
FRANK SMITH
FRED LONG
KATIE KIT
in a drop down box, can i let excel automatically select one of those names?
thanks for your help in advance!
aidan g
Bookmarks