Autofilter: Save a custom sort?

  • Thread starter Thread starter Joe Blow
  • Start date Start date
J

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
 
-----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,
Click to expand...

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

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
Click to expand...

Hi Peter,

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

Best regards,
Joe
 
Back
Top