I have two dependent drop down lists and I want to insert a function/macro to toggle through each possible option on the drop down list at random. Any help would be greatly appreciated!
I am looking for a way to make a button that will randomize a section of cells. Some of my lists are quite long and the RAND() function in the adjacent cells is not very useful for me. Any Suggestions?
Thanks,
Andrew