Auto Complete in a Data Validation cell technique (feedback wanted)

JB,

I think this is a great technique and, frankly, don't see how the lists can be further refined given the wide disparity of possible names.

It isn't intuitive to select from twice from separate lists the same drop down, so possibly the first selection in each name list might be "choose a name". You included notes to tell us to do this but, obviously, such a note as presented would not be shown in the finished product.

I like this and, shamelessly, will "borrow" it. Thanks for sharing.

Palmetto

Originally Posted by Palmetto

It isn't intuitive to select from twice from separate lists the same drop down

Good point, in application, yes I would have to include some training to aid them in getting familiar with the technique.

I like this and, shamelessly, will "borrow" it. Thanks for sharing.

That's the goal! Go for it. When you do, please come back and feedback how it actually pans out in your real application. I can fathom how only two cells could be used to choose from a wide variety of "options" for customizing a product, like a T-Shirt, you know? Would like to see this actually work out for use.

Jerry