Exel Sort Criteria

  pj123 12:33 23 Aug 08
Locked

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 08

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 08

Thanks VoG™.

Will give the macro a go and post back.

  jaraba 16:04 23 Aug 08

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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

Prehistoric Britain is laid out in these Royal Mail stamp illustrations

Best running headphones | Best sport & fitness headphones: 4 brilliant pairs of wireless…