• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Dependent DropDowns

K

Kavfam

New Member
Hi All. I am new to this site but look forward to being a member and sharing ideas and solutions. I have multiple dropdowns for an orders sheet, each depends on the first dropdown, Model. I am using Tables and Named Ranges and the Offset function to extract conditional data. All working fine - see attached file. I will be adding about 15 Tables in addition to Series, Voltage, Wattage, but this requires 2 named ranges for each table, used in Offset Function. Is there a more efficient way to do this? Thanks for taking a look.

Patrick
 

Attachments

Thanks David. I didnt see that. Just checked it. Beautiful. My dropdowns though each just depend on the first dropdown, not cascading subcategories. Also, its a bit different in that the entries in each dropdown vary according to the model chosen. So I don't think I can use this but thanks for the link.
 
Kavfam said:
Thanks David. I didnt see that. Just checked it. Beautiful. My dropdowns though each just depend on the first dropdown, not cascading subcategories. Also, its a bit different in that the entries in each dropdown vary according to the model chosen. So I don't think I can use this but thanks for the link.
Click to expand...

Can't you build a single table with all the variables and then filter out based on successive selections?
 
Thanks for the suggestion. I started out with a single table 2 dimensional with component as columns and rows as models. But because each components can have none, one or multiple options i have multiple rows for same model. Didnt get far so slipped back into my database comfort zone and went the separate tables. I kept fighting that the structure i had wasnt correct. Ex shown below.

But since i have a working solution i will look at the single table again and see if i can figure something. As you suggest, there may be a neater solution avoiding all the named ranges and without having to go to code.

Ex. Single table
Model Series Volt Watt ... Comp4..
A 1 120 50
A 2 240 75
B 12
C A 24 30
C B 120 75
C C 220 100
..
 
You must log in or register to reply here.
Back
Top