Re: Data validation

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Debra Dalgleish <dsd@xxxxxxxxxxxxxxxxxxxx>
Date: Fri, 19 Aug 2005 14:02:31 -0400

There's a formula solution here, that hides previously used items:

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

RARomeo wrote:

I want to setup a data validation list to allow users to only select from a drop down box. Is it possible that once the name is selected from the list, it is automatically deleted from the list and therefore not available after a one time selction?

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

References:
- Data validation
  - From: RARomeo

Prev by Date: Re: Color Index
Next by Date: Re: new ***
Previous by thread: Re: Data validation
Next by thread: Printing at certain times of a day
Index(es):
- Date
- Thread