Exel Sort Criteria

  pj123 12:33 23 Aug 2008

I have 2 spreadsheets, both separate and both doing different things.

They both have 2 columns that need sorting as and when I change the input. Generally once a fortnight.

One spreadsheet has the search criteria “sort by column L descending and then by column K descending” and every time I do a Data Sort that works OK.

The other spreadsheet has search criteria “sort by column R descending and then by column Q descending” but when I try a Data Sort on this I have to re-enter the criteria all over again every time.

Any ideas, please?

  VoG II 13:15 23 Aug 2008

Excel stores sort criteria within a session of using it but as far as I know it doesn't 'remember' the criteria for individual files.

Why not record a macro when you do the sort. You could then assign it to a keyboard shortcut or a button on the sheet.

  pj123 15:43 23 Aug 2008

Thanks VoG™.

Will give the macro a go and post back.

  jaraba 16:04 23 Aug 2008

You could also try the Data/Filter/Autofilter.
this puts a drop down selection at the top of each column which has a sort ascending or descending option.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

WPA2 Hack Latest News: How Secure is your Wi-Fi?

Photoshop CC 2018 released with new Curvature Pen and better brush tools

Best kids apps for iPhone & iPad

Comment utiliser Twitter ?