Hi

If you create a data validation over the top of an existing entry, it will retain the existing entry even if it isn't a part of the list.

Problem is going to be creating the drop down list for all entries if you have a heap of them. How many do you have to do?


rylo