Needdrop down menu with two choices as "High Interest Rate Method" and "Snowball Method."

Hi experts,

Could you please help in below scenario.

I need a drop down menu with two choices as "High Interest Rate Method" and "Snowball Method." for D10 and E10 cells f
then

from the cell if user select "High Interest Rate Method" choice the columns values (rows 12-26) automatically sorts the table by Column D (rows 12-26) from highest interest rate to lowest interest rate of entire row .
or
from the cell if user select "Snowball Method." choice the columns values (rows 12-26) automatically sorts the table by Column D (rows 12-26) from lowest interest rate to highest interest rate.

same thing for E10 cell as well.

Thanks,excel scenario.xlsx
Nani

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.