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