Data validation

W

Wereman

I have a list of names (A1:A10).
1. How do I make a dropdown box with these names appear in B1?
2. Once I've chosen a name from the list in B1, how do I make the next
dropdown box (B2) contain all the names less the one from B1?

Any help would be much appreciated.

John
 
M

Max

Wereman said:
I have a list of names (A1:A10).
1. How do I make a dropdown box with these names appear in B1?
2. Once I've chosen a name from the list in B1, how do I make the next
dropdown box (B2) contain all the names less the one from B1?
Click to expand...

Try Debra's page at:
http://www.contextures.com/xlDataVal03.html
Excel -- Data Validation -- Hide Previously Used Items in Dropdown
 
Top