Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sort Ascending/Descending
I have two columns in a spreadsheet labeled Project No. and Project Name. As
users continually add entries to those columns, I want to create a button called "Sort by Project Number" at the top that toggles between ascending and descending order (in other words, if the Project No. column is already sorted in ascending order, then clicking the button sorts it in descending order, and vice versa). If it's not sorted, then sort it in ascending order. I know the sorting buttons exist on the toolbar, but these users need something simple and obvious, and doing it with one button would help. Thanks! Steve C |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Ascending Sort formula, change to neg #: descending sort.. | Excel Discussion (Misc queries) | |||
Sort Ascending or Descending using Option Button | Excel Programming | |||
sort function - from ascending to descending | Excel Programming | |||
Sort other than by alphabetical ascending/ descending | Excel Discussion (Misc queries) | |||
how can I hide sort ascending and sort descending options in the . | Excel Discussion (Misc queries) |