Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() -----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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Custom Sorting a linked work sheet | Excel Discussion (Misc queries) | |||
sorting and adding cells in different work sheet? (hard stuff) | Excel Discussion (Misc queries) | |||
extracting totals from 1 work sheet to another work work sheet | Excel Discussion (Misc queries) | |||
Sorting Identical Data set in a work sheet | Excel Worksheet Functions | |||
Realtime Automatic sorting of data in rows in new work sheet | Excel Worksheet Functions |