multi drop down list

[mahmoud-lee]

Explanation inside Sheet

[Ingolf]

mahmoud-Lee,

It is better to explain what you want directly in the post, are more likely to receive a response. There are people who can not / will not open attachments. In file you write "I want many of the drop-down menus, Which depends on the choice of the first list". What should be understood here as you want?

[mahmoud-lee]

I want this really
"I want many of the drop-down menus, Which depends on the choice of the first list"
Thank you for the clarification

[alansidman]

It appears that what you are looking to do is called dependent combo boxes or cascading combo boxes. Here is a link on how to do that.

Cascading Combo Boxes in Excel | The Office Corner

[alansidman]

Cross posted: multi drop down list
Please read this: Excelguru Help Site - A message to forum cross posters