Data Validation Autocomplete

Thanks for your reply,

I've have been there before, but I still have problems getting the validation to work correctly, it work untill I need to add and/or remove bus numbers.
Regards

David

Hi,

VBA Noob is right ...

For data validation with the Autocomplete feature, Debra's solution is the perfect solution ...and it working well, provided the user remembers he has to double-click the cell ...

@ David, regarding "bus numbers" you only have to adjust your ranges ...


HTH
Carim