Disappearing Drop-down Box in Excel
 

want to create a drop-down list in Excel that removes the entry once it is
used. That is, the entries that have not been used remain viewable and
available to the user, those that have been used are not shown in the list.

Anyone ever done this in Excel?

Disappearing Drop-down Box in Excel
 

On May 14, 7:56 am, Bill wrote:
want to create a drop-down list in Excel that removes the entry once it is
used. That is, the entries that have not been used remain viewable and
available to the user, those that have been used are not shown in the list.

Anyone ever done this in Excel?

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

Ken Johnson