Need drop down menu with two choices with some functionality

[sqlindia]

Hi experts,

Could you please help in the 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

[JBeaucaire]

1) Insert your drop down data validation list into cell G10 so that it doesn't actually touch the data table.

2) Right click the sheet tab and select View Code, paste in this event macro:

Please Login or Register  to view this content.

3) Close the VBeditor and save your workbook as a .xlsm file so the macro will work when the workbook is opened next time

4) Now make a change to your G10 cell.

[sqlindia]

Thanks JBeaucaire for the solution you give , It is working good.

one more request , as I said we need to apply sort on only for some set of rows

I mean Assume if the column D have values in row 1 to 100 , here we need to apply sort only for the rows13 to 25 when we select "High Interest Rate Method"

same for Snowball Method as well

I was unable to add the range condition on VB code .
could you please help me on this.

PFAexcel scenario (1).xlsm

Thanks!

[Winon]

JBeaucaire gave you Code based on a specific layout of the Data on the Sheet.

Now if you move that Data, insert Lines or Columns, or alter it in any way, the Code has to be adjusted accordingly.

In the attached WorkBook I have done that for you, and adapted the Code to sort only on the rows 13 to 25.

Also see the "Please consider" note at the bottom of this post.

@ JBeaucaire,

If you don't mind Jerry.

[JBeaucaire]

That's a good edit, Winon.

sqlindia, if that takes care of your original question, please select Thread Tools from the menu above and mark the thread as solved. Thanks.

[Winon]

@ JBeaucaire,

Credit from a Master. I am flattered!

Thank you Jerry.

[sqlindia]

Thanks , working great