Thanks, that worked great!!! I have an ever growing list of items for my
drop down list, what is the best wasy to continually update that list?

"jamesebailey72" wrote:



"Debra Dalgleish" wrote:

There's a sample file on my web site that uses Data Validation and
VLookup to complete an order form. You could use the same technique for
your worksheet:

http://www.contextures.com/xlOrderForm01.html

WoodyAccess wrote:

--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com