Hi,

I'm using the Data Validation list to create a drop-down menu. It's getting the list from elsewhere on the same page - a list of names. But I'd like it to be possible to delete a name separately whilst the drop-down menu just ignores the existence of that blank cell when using the drop-down. Also, I need to be able to add new names and have the list remain in alphabetical order.

Any ideas?

Thank you so much.

Florian