I have attached a sample Excel workbook. I want to be able to work with 5 drop down lists. All of the lists are the same. There are 5 items in each of the dropdowns, and at any given time, each dropdown list item displayed will NOT be duplicated in any of the other 4 dropdowns. I want to be able to select any of 5 items in a specific dropdown list, and have the items "swap".
I know above is not a very good explanation. Hopefully the sample attached will show what I need better than this explanation.
Thanks in advance.