Data Validation List Additions

[Graham]

I have a column where all the cells are set for data validation. The data is
in a dynamic list.
On occasion there will be a new entry appear which is not on the list but
the data validation is set
so that the entry can be made with a message appearing identifying that it
is a new entry. There is
an option via a procedure to go to the list and add the new entry so that it
will be in the list if that entry should ever appear again. What I was
wondering if it was possible to have a procedure, perhaps a cell change
event to add any new entries every time they appeared without the user doing
this himself. I tried copying all the column entries that had been made and
doing an advanced filter to extract unique values to the list location. This
has so far not proved particularly effective and I would be grateful if I
could be pointed in the right direction.

Kind Regards,
Graham Haughs
Turriff, Scotland.

 

[Debra Dalgleish]

There's a sample file here that will automatically add new entries to
the data validation source list:

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

Under 'Data validation', look for 'Update Validation List'.

You'll have to turn off the error alerts so that users can add values
that aren't in the list.

 

[Graham]

Thank you very much Debra, you are a star!

Graham