I would approach this very differently.

1) Create your list as you seem to have done.

2) Create an order form on another sheet and use VLookup (possibl
incorporating DataValidation to "pick from list". So in a cell of you
choice you would type/select the product and other details would sel
populate.

3) More advanced using VBA would be a userform with a listbox showin
products to select from

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com