Dependent Drop-Down Lists

[King_Louie]

Currently have a series of dependent drop lists using Tables and indirect formulas using the below formulas. It works perfectly but I would like to find a way to maintain a single table as per the below versus have to create multiple tables to ease with data modification such as, (1) new variant (e.g., EV), modify name (e.g., Sport i/o Performance) and/or want to add additional dependent drop-down lists (e.g., column for Color)?

Manufacturer=ManufacturerList (named table reference)
Style: =INDIRECT(SUBSTITUTE(A1," ","_"))
Model: =INDIRECT(SUBSTITUTE(B1," ","_"))


Capture.PNG

[torachan]

see attached, you could do it in this manner by adapting and expanding the macro in the sheet module - self maintaining - no formula to bother about - tables expand dynamically - to demo put quantity in 'F2' then move across cell by cell, then put quantity in 'F3' and repeat - to expand reference table simply type a row immediately below and the table will expand to include it.

[Croweater]

Are you happy to use VBA? Attached is a workbook I did some time ago for someone.

Have a look at it. If you are interested I will help you adapt it to your own personal workbook.

The first example chooses a default option but colours it red if there are alternative selections.
The second only fills in automatically if there is only one selection.

[King_Louie]

I'm a complete noob with macros so preference is to avoid at all costs. Is it possible?

Should mention the drop-down lists needs to be repeated on several row. E.g., user selects selection on row 1, then moves to row 2 for another entry, and so on.

[Croweater]

So you have something which works perfectly, but you want to improve efficiency and maintainability without VBA? Correct?

I think you need to put up your existing workbook, so we can see what you want to improve on.

[King_Louie]

Yes

I cannot upload the actual spreadsheet but hopefully the below screenshots provide enough context to the query.

Form.jpg
Tables.jpg

[King_Louie]

Any non macro solutions?

[Croweater]

Why can't you put your workbook up?

I don't work with pictures and I'm sure there are a lot like me.

[King_Louie]

Had to create a new spreadsheet to remove all original data.

I am wanting to use only one source table (columns G-I) for the dependent dropdown list vs having multiple tables (columns L-AA).

Thanks

Example.xlsx