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??

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??