Dropdown

[dominickmcintyre]

Hi,

I am trying to find out if there is a possibility in Excel to create a dropdown list, which will be applied in a specified field, but with the addition that once an item has been selected, it will no longer be available in the list, when opening the dropdown in a different cell within the specified field.

Any geniuses awake?

 

[Akashwani]

Hi, Welcome to MrExcel.

This video does exactly as you require....

http://www.youtube.com/user/ExcelIsFun#p/search/4/1t4yl7P7-9A

Good luck.

Ak