Sorting a Work sheet - using drop down box ??

N

Neil

Hi there, i have an example sheet here:

www.dj-jammy.com/test.xls

im want to be able to sort the countries on the left, by who has the highest
figures for that month, at the top ,and the lowest at the bottom, but, i
want to be able to select which month i want to find out for by a drop down
menu;

e.g.,

i select march from my drop down menu, and it sorts the sheet, with canada
at the top, and uk at the bottom (and obviously the appropriate ones in
between), but, if i then select may from my drop down box, it places poland
at the top, and usa at the bottom.

How would i do this - im not a programmer, so be careful wth me :)


apologies for cross posting,

Regards,
Neil
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Link a text box based on drop down box with four options MS Word 365 0
Formatted cell column in drop down list 1
Protecting sheets with drop down boxes 0
Drop Down Sort Button. 2
Drop Down List Dependant Formula 2
Using a drop-down box to sort data based on seperate columns 2
Drop Down Starting Position 2
Advanced Drop-down Menu 2

Top