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

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

You need to name the product list (Insert>Name>Define...), and then use data
validation (Data>Validation) 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" <[email protected]>
wrote in message
news:[email protected]...
>
> 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
>