Autofilter: Save a custom sort?

[Joe Blow]

HI,

Is there a way to save a custom sort for Autofilters? I find myself
using the same custom sorts over and over again. Is there a way to
save the sort criteria as a std sort option?

Thanks,
Joe

 

[Peter]

-----Original Message-----


HI,

Is there a way to save a custom sort for Autofilters? I find myself
using the same custom sorts over and over again. Is there a way to
save the sort criteria as a std sort option?

Thanks,

Joe

You could save the file with the filtersstill in palce, or
You could record a macro while you perform the Autofilter
and run this every time.

Alternatively, use an Advanced Filter and save the
criteria somewhere on the sheet.

Regards
Peter Atherton

 

[Joe Blow]

Joe

You could save the file with the filtersstill in palce, or
You could record a macro while you perform the Autofilter
and run this every time.

Alternatively, use an Advanced Filter and save the
criteria somewhere on the sheet.

Regards
Peter Atherton

Hi Peter,

I went with the record macro option. Works great. Thanks for saving me
all of that wasted effort!

Best regards,
Joe