Have a list generate a list

[Gtotheurra]

Hello fellow Excel users

I have a problem problem which i will try to describe with an exempel.

I attached an excel file. In cell A3 i have a list of the manufacturers. In cell C3-F3 i have lists of models.
I want cell A3 to spawn a certain list with models depending on which manufacturer you picked, and i want diffrent lists to spawn on the same cell depening on the manufacturer.

If someone could help me solve this that would really help e with alot of spreadsheets i have.

Sincerly Gustav

[mikeava]

Try this, let me know if you have any questions

[Gtotheurra]

That is Amazing! But I have no idea how you did it

I cant see any forumlas from the excel file when i download it

[AliGW]

@Mikeava

Sorry for off-topic interjection:

Although there is no official rule regarding this behaviour, we request that wherever possible both the question AND the answer be provided in substantive detail here within the thread. An attached workbook is an excellent aid for posing a question and offering a solution, but solely doing that with no in thread explanation makes it difficult for researchers to understand or consider the Q & A of this thread without downloading what may be a pointless doc to them, if they can do that at all. Doing that also hides the content from search engines so others may never benefit from this.

I'm sure you understand, and we look forward to seeing you post your formulas/macros in your posts for the searching benefit of all.

[alansidman]

What you are looking for are called cascading combo boxes

Here is one link to how to make that happen--> https://mauriceausum.com/2011/07/12/...oxes-in-excel/

[mikeava]

No problem at all. Glad I could help.

Not sure if you'll be adding to the lists or not -- I only used info that you had on your file. But this is what I did.

First you have to give each list a name:
So select all the car brands in column K
Go to Formula Tab
Click on Define Name - then Define name again.
Type a name in the name box, ie Cars.
Click OK.

Then select the models under Volvo and repeat the same steps (name the list Volvo)
Do same for each car brand.

Highlight a number of cells in Column A under Car Brand
Click on Data tab
Click on Data Validation.
Choose List from Allow
In Source type in =Cars (the name of the list you created).

Select a car from that list.
Under Models (in C3) click on Data Validation
Choose List again
This is how it's going to be linked together.
In Source box type =Indirect(A3)
Click OK
Bingo you're good to go

[mikeava]

Ali - I realized that after I posted it. Sorry about that.
Just gave the steps

[torachan]

There is no need to have a separate makers column.
Simply use the column headers as your first data validation range (=$M$3:$P$3)