Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down list predicated on other drop down lists
I am creating a part numbering system using drop down boxes. Drop down box 1
consists of main categories. Drop down box 2 is for sub categories of drop box 1. I need to kow what function(s) to use to so that drop down box 2 only supllies valid options based on the value in drop box 1. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down list predicated on other drop down lists
hi
what kind of drop down? combo box? data validation? see this site for starters. the first page is for data validation. but there are other pages for combo boxes. snoop around. http://www.contextures.com/xlDataVal02.html regards FSt1 "ab-original" wrote: I am creating a part numbering system using drop down boxes. Drop down box 1 consists of main categories. Drop down box 2 is for sub categories of drop box 1. I need to kow what function(s) to use to so that drop down box 2 only supllies valid options based on the value in drop box 1. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Drop Down list predicated on other drop down lists
Hi,
You need the OFFSET function as demonstrated in this example: Here are the steps for creating a dynamic data validation list: 1. Create three or more list in the spreadsheet. For example: A B C New York Quebec Canada Seattle Toronto US Miami Victoria You would name lists: US (A1:A3), Canada (B1:B3), Countries (C1:C2) this last is optional 2. Select the cell where you want the initial validation list, for this example, D1 3. Choose Data, Validation 4. From the Allow drop-down and choose List 5. In the Source box enter the following formula =Countries 6. Move to the location where you want the dynamic (changing) list to appear, say for example E1 7. Choose Data, Validation, List and in the Source box enter the formula =INDIRECT(D1) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "ab-original" wrote: I am creating a part numbering system using drop down boxes. Drop down box 1 consists of main categories. Drop down box 2 is for sub categories of drop box 1. I need to kow what function(s) to use to so that drop down box 2 only supllies valid options based on the value in drop box 1. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop down lists that auto create and then filter the next drop down list | Excel Worksheet Functions | |||
how do I use one drop-list to modify another drop-lists options? | Excel Discussion (Misc queries) | |||
Multiple blocks (double column lists) turned into drop down list | Excel Discussion (Misc queries) | |||
How do I create drop-down list boxes from multiple lists/headers | Excel Worksheet Functions | |||
Drop down lists are displaying end of list, how to make it top? | Excel Worksheet Functions |