Lists

[jaycee]

Hi

On my spreadsheet I am using a list of names (called Names), these are used in a drop down list. What I want is that when a name on the list has been used in 1 column then it can no longer be selected again for that column, but can be selected in another column.

Any ideas?

Cheers

 

[VoG]

This may help you http://www.contextures.com/xlDataVal03.html

 

[jaycee]

Excellent many thanks