Thanks, Debra!.

I unzipped your worksheet. However, when I click on the dropdown and
choose a product, the product and id remain, does not automatically
fill in just the product name. Also, I selected enable macros.


--
pyarb
------------------------------------------------------------------------
pyarb's Profile: http://www.excelforum.com/member.php...o&userid=26803
View this thread: http://www.excelforum.com/showthread...hreadid=400570