Creating a Product List

C

changetires

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
 
B

Bob Phillips

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]...
 
Top