second level sorting using selections from droop down lists

Hi all, good day!

I have a list and would like to give the users two level sorting options.

I have 5 columns and the users can choose from drop down 1 as first level and drop down 2 as second level. I have create the drop down lists for both levels, where the users cannot select the same category in drop down 2 as the same in drop down 1. after making the selection, then there is a button for the users to click for sorting.

I am capable of doing one level sorting, however, when it comes to level 2, I have no way but to write the codes for ALL options, which is very long and not efficient.

Would appreciate if anyone can assist in helping for a shorter and dynamic codes.

Thank you!

Attached is my sample workbook without codes, just the design of how my drop down lists and button should look like.

hi, thank you for the reply.

I tried with the given codes, however, it is not working properly.
It sorts based on first level but not the second level....

Appreciate your assistance.

Thank you

hm... i don't know what went wrong then.
The first level is working fine but the second level is not.
I compared it using the result I do manually.
The second level is showing neither ascending nor descending. The sequence of the data just jumbled up?

wow... i don't know why but mine is not working although i copied the codes exactly the same.
thank you!

one more question though, can i use named range for my table? i need to move around my table and it's not necessary starting from A1.

i just replaced A1 with the named range?

thank you!

I am so sorry, i missed out something and realized that when I put the codes into my actual data sheet.
As shown in the attached file in my first post, I have two columns of text data (which are names actually).
When these two columns are chosen, I need them to be sorted in alphabetical order (ascending) and if the rest (numbers) are chosen, they will be sorted in descending order.

Any ideas?

Thank you!

Hi I managed to sort it out.
Thank you very much for your kind assistance