Creating a Product List
 

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

Creating a Product List
 

For Dropdown lists check out:
http://www.contextures.com/xlDataVal01.html

Creating a Product List
 

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

Creating a Product List
 

That worked great but how do I make the pull down arrow stay on?

Ed


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