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