| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Creating a Product List
|
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a concatenate text list by referencing an array | Excel Discussion (Misc queries) | |||
| question about creating a simple drop down list | Excel Worksheet Functions | |||
| Creating a Product DATABASE in ACCESS or EXCEL and then retrieving | Excel Discussion (Misc queries) | |||
| Creating seperate sheet lists from larger list | Excel Discussion (Misc queries) | |||
| Cleaning Product Code list | Excel Worksheet Functions | |||
Hybrid Mode
