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

"Wereman" wrote:
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?

Try Debra's page at:
http://www.contextures.com/xlDataVal03.html
Excel -- Data Validation -- Hide Previously Used Items in Dropdown
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

Click on B1
Click on the Data menu
Click on Validation
Under Allow: Click on List
Click inside of the Source box but do not type anything
Now scroll down and highlight all the names
Then click OK
Done.
Whatever names you scroll and highlight will appear in the drop down list.
Create a new drop down list minus the first name in B2
Goodluck.



"Wereman" wrote:

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