Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default Sorting a Work sheet - using drop down box ??

Hi there, i have an example sheet he

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


  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 57
Default Sorting a Work sheet - using drop down box ??


-----Original Message-----
Hi there, i have an example sheet he

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 i will

do it for you. The one of the web i get errors in, think
it excel problems rather than the sheet.

Nath
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom Sorting a linked work sheet Derro Excel Discussion (Misc queries) 2 July 2nd 09 02:36 AM
sorting and adding cells in different work sheet? (hard stuff) doyree Excel Discussion (Misc queries) 8 February 13th 08 12:37 AM
extracting totals from 1 work sheet to another work work sheet cj Excel Discussion (Misc queries) 2 October 27th 07 10:54 PM
Sorting Identical Data set in a work sheet SAT Excel Worksheet Functions 0 September 13th 05 10:46 PM
Realtime Automatic sorting of data in rows in new work sheet Gazzali Excel Worksheet Functions 0 June 23rd 05 09:35 AM


All times are GMT +1. The time now is 10:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"