Validation List -adding data and using it later
 

Hi all, I've been searching the site and haven't found an answer to my
question.

I'm trying to use a validation list to allow entry of medical diagnosis.
Since there are lots of diagnosis, I need my list to be able to be added too.
I would *like* to have it setup so that any user can enter a "new" diagnosis
on the worksheet, and it will be added to the validation list on the
"sheet1". Also, any user after that when they activate the drop down box
under "Diagnosis" can see that "new" diagnosis listed along with all the ones
I have originally entered.
Is what I'm wanting to do possible with Excel?
Thanks

Validation List -adding data and using it later
 

Hi!

You can create a dynamic named range for the diagnosis list.

http://contextures.com/xlNames01.html#Dynamic

Then, just use this named range as the source for the drop down.

Biff

"POC" wrote in message
...
Hi all, I've been searching the site and haven't found an answer to my
question.

I'm trying to use a validation list to allow entry of medical diagnosis.
Since there are lots of diagnosis, I need my list to be able to be added
too.
I would *like* to have it setup so that any user can enter a "new"
diagnosis
on the worksheet, and it will be added to the validation list on the
"sheet1". Also, any user after that when they activate the drop down box
under "Diagnosis" can see that "new" diagnosis listed along with all the
ones
I have originally entered.
Is what I'm wanting to do possible with Excel?
Thanks