Saving a Custom Sort

  • Thread starter Thread starter SH in FL
  • Start date Start date
S

SH in FL

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
 
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
 
Back
Top