dropdown2/combobox2 list will update based on combobox1/dropdown1 value

[serenitylai]

Hello everyone,

I just need help on this.

I'm not sure if macro is still needed on this or not however what I need help on is that I need a dropdown or a combobox to be added on worksheet1 ex:

1st dropdown will be on Sheet1 A2 that you can choose a class and if class 1 a or class 2 b, etc.
the list will update on dropdown 2 in Sheet 1 B2 based on the class they are on.


Thank you for those who'll help me out.