| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Repeating a sort
I have a list which I update regularly and need it to be kept in a certain
order. But everytime I go to sort it I have to choose all the same options again (no header, sort by column D, column B, column A). Is there any way to set all these options so I can just press a button and it automatically searches using these options? Or better yet an automatic sorting of rows in realtime? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Repeating a sort
record a macro to do what you want. When you're done, create a button (use
the Forms toolbar - View/Toolbars/Forms), assign it to the macro you just recorded. "john" wrote in message ... I have a list which I update regularly and need it to be kept in a certain order. But everytime I go to sort it I have to choose all the same options again (no header, sort by column D, column B, column A). Is there any way to set all these options so I can just press a button and it automatically searches using these options? Or better yet an automatic sorting of rows in realtime? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to sort on data field | Excel Discussion (Misc queries) | |||
| how to sort anything that looks like a number as a number | Excel Discussion (Misc queries) | |||
| Select rows and sort based on type | Excel Discussion (Misc queries) | |||
| Trying to create repeating dates and then sort column by date | Excel Worksheet Functions | |||
| Why have I got some repeating rows after a Excel 2003 sort | Excel Discussion (Misc queries) | |||
Linear Mode
