Take a look at this article from Debra Dalgleish's site:

http://www.contextures.com/xlDataVal03.html

Hope this helps.

Pete

On Apr 4, 1:50*am, Lost Cluster
wrote:
I have a drop down list with names in it. I need the names to disappear as
they are being selected when you go down to the next row, so when you get to
the last row there should only be one name left. *Thanks.