discard values from data validation drop down list
I must fill 100 cells with names from a list. I use data validation. Is it possible to discard from the list names that i have already selected in previous cells? I would like to do it even with complex formula or macro. Exemple List of names A B C D In first cell, i select B. When I open the drop down in second cell, i would like to see only A, C and D.