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

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

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

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