Sorting a Work sheet - using drop down box ??

  • Thread starter Thread starter Neil
  • Start date Start date
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
 
-----Original Message-----
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


.
If you send me the sheet to (e-mail address removed) i will
Click to expand...
do it for you. The one of the web i get errors in, think
it excel problems rather than the sheet.

Nath
 
Back
Top