Forum Discussion
Need help with dynamic dependent drop down list...
Hey Guys! I'm trying to make a excel sheet that has one array of options depending on another array... I want to creat two drop down list. List 1 is choosing from A&B, then depend on th...
As variant:
Let define ListA as
="a"& SEQUENCE(Dimension)and SublistsA as
=$B4&"-"&SEQUENCE(1,Dimension)Same for B.
Data validation for list
and for sublist
SergeiBaklan Thanks a lot!!
