Explanation inside Sheet
Printable View
Explanation inside Sheet
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?
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
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
Cross posted: multi drop down list
Please read this: Excelguru Help Site - A message to forum cross posters