Drop down list within drop down list

[jackson_hollon]

Hello,

I am not sure what this kind of drop down list is called. I want to create a drop down list that will have 4 choices (Red, Yellow, Green, and White). When I select red, another drop down list will show up (with in the same cell). This second list will have T-Shirt, Skirt, and Shoes.

I can only find online that show how to create a drop down list in a cell, then when the selection is chose, THE OTHER selection will be in another cell. This is not what I want.

Please point me to the right direction. Let me know what that is call and I will search it online.

Thanks.

Jackson

[MarvinP]

Hi Jackson,

I think you are looking for Cascading Dropdowns.

https://www.ablebits.com/office-addi...n-lists-excel/

I'm not sure you can redefine the dropdown in the same cell like you seem to want, without some VBA.

[jackson_hollon]

Marvin,

I had done researched for this subject for the last 2 days. I believe this cannot be done without using VBA.

Thanks for the help.

Jackson