| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Saving a Custom Sort
Good afternoon!
Can anyone tell me if there is a way to save a custom sort for future use. We have a complex sort that I would love to have available without having to create it each time. Very best regards and thanks in advance! SH |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Saving a Custom Sort
Record a macro just before you do your sort, and run it each time you want to
do this sort procedure. http://www.anthony-vba.kefra.com/vba...ur_First_Macro Regards, Ryan--- -- RyGuy "SH in FL" wrote: Good afternoon! Can anyone tell me if there is a way to save a custom sort for future use. We have a complex sort that I would love to have available without having to create it each time. Very best regards and thanks in advance! SH |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Saving a Custom Sort
A macro would probably be your best bet:
Turn on the recorder (Tools/Macro/Record New Macro...) Name the macro Click OK Click on a cell in your data Use the Data/Sort command as you wish and click OK Stop the recorder (Tools/Macro/Stop Recording if you don't see a stop button on a toolbar) If you want to follow up with a button on your spreadsheet: Use Tools/Customize to display the Forms toolbar Click the Button button (it looks like a brick) Drag on your sheet to make the button Select your macro from the list when prompted Click OK Type a caption for the button Hit the [Esc] key twice to deselect the button On May 23, 4:07 pm, SH in FL wrote: Good afternoon! Can anyone tell me if there is a way to save a custom sort for future use. We have a complex sort that I would love to have available without having to create it each time. Very best regards and thanks in advance! SH |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Saving a Custom Sort
Excellent, thank you!
SH "ryguy7272" wrote: Record a macro just before you do your sort, and run it each time you want to do this sort procedure. http://www.anthony-vba.kefra.com/vba...ur_First_Macro Regards, Ryan--- -- RyGuy "SH in FL" wrote: Good afternoon! Can anyone tell me if there is a way to save a custom sort for future use. We have a complex sort that I would love to have available without having to create it each time. Very best regards and thanks in advance! SH |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| custom format saving | Excel Discussion (Misc queries) | |||
| Saving Sort Criteria (or Sort Lists) | Excel Worksheet Functions | |||
| Saving with Custom Charts | Charts and Charting in Excel | |||
| Excel sort by Fill Color by custom list sort | Excel Discussion (Misc queries) | |||
| custom format & saving | Excel Discussion (Misc queries) | |||
![SH in FL[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
