Hello Everyone,
I need to create dropdowns based on another drop downs. I know to create using data validations, but there are 100's of values in dropdown. Hence thinking of using vba code. Anyone, please help me out. The data is in the below format in different columns. Like if I select A in dropdown, AA1 should appear or if I select B, BB1 & BB2 should appear in another dropdown.
A AA1
B BB1 BB2
C CC1
D DD1 DD2 DD3
E EE1 EE2 EE3 EE4
Thanks in Advance.
Best Regards,
Abhi
Bookmarks