Hi rick,

Now I understand. Auto fill for data validation is to my knowledge not
possible, which is not to say that it isn't. You should post this again in
this forum, as there are many others who may know how to do this.

Otherwise if it's possible, you could via control toolbox, insert a
combobox, which will autofill. However, you would need to link it to the
source, and then modify your formulae.