You need to name the product list (InsertNameDefine...), and then use data
validation (DataValidation) with Allow of List, and type the range name in
the edit box, preceded by =.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"changetires"
wrote in message
...

In sheet 1 I want to have a pull down menu of a product list in cell B2.
The product list will be on sheet 2. When I click on the arrow on the
pull down menu I want all the products listed to chose from. How do I
do this?

Ed


--
changetires
------------------------------------------------------------------------
changetires's Profile:
http://www.excelforum.com/member.php...o&userid=35414
View this thread: http://www.excelforum.com/showthread...hreadid=553207