J
Joey Spreadsheets
I don't know if this is possible within excel or if you have to use another
program like Access to do it. I would love to see is some Excel Genius could
help me out.
I'm trying to create a dropdown list based on what value was selected in a
previous cell's dropdown list. Here's a simple example...
The first dropdown list allows you to pick either 'Burger' or 'Soda'.
Depending on which is selected, then second dropdown gives you a different
set of options:
- If 'Burger' was picked, then it gives you only the choices 'Plain' or
'Cheese'.
- If 'Soda' was picked, then it gives you only the choices of 'Coke',
'Sprite' or 'Root Beer'.
This is a very simple example, but I'm trying to apply this same logic to
something that would have 6 different dropdowns going across the columns and
each of their lists would be dependant upon what was selected in the previous
dropdown. Also, each list would consist of about 20 different values, so
this gets to be very large. If someone can explain how to do it with
Burger/Soda example above, then I could apply it to the bigger task at hand.
Please tell me SOMEONE reading this is smart enough in Excel to figure it
out and explain it. It would be a HUGE life saver! Thanks
program like Access to do it. I would love to see is some Excel Genius could
help me out.
I'm trying to create a dropdown list based on what value was selected in a
previous cell's dropdown list. Here's a simple example...
The first dropdown list allows you to pick either 'Burger' or 'Soda'.
Depending on which is selected, then second dropdown gives you a different
set of options:
- If 'Burger' was picked, then it gives you only the choices 'Plain' or
'Cheese'.
- If 'Soda' was picked, then it gives you only the choices of 'Coke',
'Sprite' or 'Root Beer'.
This is a very simple example, but I'm trying to apply this same logic to
something that would have 6 different dropdowns going across the columns and
each of their lists would be dependant upon what was selected in the previous
dropdown. Also, each list would consist of about 20 different values, so
this gets to be very large. If someone can explain how to do it with
Burger/Soda example above, then I could apply it to the bigger task at hand.
Please tell me SOMEONE reading this is smart enough in Excel to figure it
out and explain it. It would be a HUGE life saver! Thanks