Limit Drop Down Menu Options Among Cells

B

BP

I have a drop down menu set up on a number of cells in one column. Problem
is, I want to be able to make a selection within that column only once.
Basically, as an item is chosen from the menu, it should no longer be
available in subsequent cells within the same column. Is this possible??
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to make items in a drop down menu reference a number 2
referencing drop down menu values in IF-then statements? 4
Copying a Drop Down Menu 2
Creating drop downs in a cell contingent on another drop down 1
Filtered drop down list 2
Drop Down choice needs to lead to another drop down menu 1
Can I make a drop-down menu without cells containing the choices? 2
How do I use different colours in drop down menus in Excel 2003? 4

Top