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 repeating drop-down lists? 2
Link a text box based on drop down box with four options MS Word 365 0
Drop down list control value in vba 2
Creating a Dropdown that is Related to the Value Given in Another Cell 6
Drop down in Graph (excel 2003) 2
Excel does not accept text format! 0
Filtered drop down list 2
Copying a Drop Down Menu 2

Top