Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nesting drop-down menus
Hi everybody
i'm working with nested dropdown menus in column A select a machine in column B choose a product (depends on the machine) in column C pick a style (based on the product and the machine) using the INDIRECT function so far, so good what i want to do: in column D, using another drop-down menu to choose a color but ONLY for certain machines i thought using defined names but lists named machine/product/style/colors would be a lot of work (4 machines * 5 products * 200 styles * 25 colors) it's there a way to program a dropdown menu to appear only when specific machines are selected?? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Nesting drop-down menus
Hi Alonso,
Try this site, it might help you. http://www.contextures.com/xlDataVal02.html Hope this helps, Gav "Alonso" wrote: Hi everybody i'm working with nested dropdown menus in column A select a machine in column B choose a product (depends on the machine) in column C pick a style (based on the product and the machine) using the INDIRECT function so far, so good what i want to do: in column D, using another drop-down menu to choose a color but ONLY for certain machines i thought using defined names but lists named machine/product/style/colors would be a lot of work (4 machines * 5 products * 200 styles * 25 colors) it's there a way to program a dropdown menu to appear only when specific machines are selected?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Drop Down Menus | Excel Worksheet Functions | |||
Drop Down Menus | Excel Worksheet Functions | |||
Drop Down menus | Excel Discussion (Misc queries) | |||
Drop-down Menus | Excel Discussion (Misc queries) | |||
drop down menus | Excel Discussion (Misc queries) |