Saving Sort Criteria (or Sort Lists)

[Guest]

In a “standard†worksheet table, I want to sort all of the data (using the
Header Row). I then want to take a chunk of this data, and sort it (No
Header Row).
Is there a way to save sort criteria? For example, could I save Sort
Criteria A and Sort Criteria B, and then invoke them when needed?

 

[Leo Heuser]

In a "standard" worksheet table, I want to sort all of the data (using the
Header Row). I then want to take a chunk of this data, and sort it (No
Header Row).
Is there a way to save sort criteria? For example, could I save Sort
Criteria A and Sort Criteria B, and then invoke them when needed?

Hi Jim

Yes, it's possible (if I have understood you correctly)

1. Enter the sort order in e.g. F3:F12
2. Select F3:F12
3. Choose Tools > Options and the tab "Lists"
4. Press "Import" and OK.
5. Save the workbook.

The sorting process:

1. Select the range to be sorted.
2. Choose Data > Sort
3. Choose the button "Options" (or similar)
4. Select your list in the listbox. OK.