List w/ validation choice sequentially fills numbers: why, why...

[pete234]

One of those "good grief" moments. I made a list of names and then named range. Then put that list in validation set. Everything fine. But needed to append (concatenate and paste values) a unique number to the names. But now when a user tries to drag an autofill, it is sequentially filling in the numbers even though they are not on the list or validated. Sort of defeats the purpose. 2003 and XP. Format does not seem to affect this behavior.

Ex: Bob Smith-112

Maybe I'm missing something simple. But it should not allow Bob Smith-113 based on the rule so why is it doing this?

 

[pete234]

Ok it seems that the problem is that the validation does not occur unless the user double clicks inside the cell. But it will still allow the false values to be saved, does not prevent this even if the error comes up. If anyone has an idea, please let me know.