multiple filter and bottom line

[kelvin_9]

greeting to all

i was thinking do i need a macro or just a normal custom sort to make it happen
1) i need to filter col_A in ascending and then col_C in below prority under a mergedcell
Lead > H1 > H2 > others

secondly:
how could i get a bottom line quickly in range a1:j500 under a merged cell for everyone like below screen cap?

thanks for your guidance

 

[kelvin_9]

greeting to all

i was thinking do i need a macro or just a normal custom sort to make it happen
1) i need to filter col_A in ascending and then col_C in below prority under a mergedcell
Lead > H1 > H2 > others

secondly:
how could i get a bottom line quickly in range a1:j500 under a merged cell for everyone like below screen cap?

thanks for your guidance

View attachment 113192

anyone can help?