Drop-down list no repeats

Hi,

I have a drop-down list (Data Validation > Allow List) for a number of cells, 12 I think, across a singe row. The values for the drop-down menu are in another, hidden, worksheet.

I would like it so the user can select any option in the drop-down list once and only once. For example, if they select Project1 in column A they then shouldn't be able to select Project1 in column B. Any ideas how I can achieve this? Ideally I would prefer not to use macros, but if needs must...

Many thanks

We need to know EXACTLY where this data is located.

Where are the drop down lists?

Where is the source for the drop down lists?

What type of data is it? Text? Numbers? Could be both? Something else?

Hi jlt,

This problem sounds like you are looking for a Cascading Dropdown. See the video at:

http://www.bluepecantraining.com/por...ists-in-excel/

I don't seem to be able to attach a file

To attach a file to your post...

Click the Go Advanced button
Scroll down until you see the Manage Attachments button and click that
Click the Browse button and select your file
Click the Open button
Click the Upload button
Click the Close Window button
Click the Submit Reply button

Good deal. Thanks for the feedback!