Saving Sort Criteria (or Sort Lists)
 

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?

Saving Sort Criteria (or Sort Lists)
 

"Jim J." skrev i en meddelelse
...
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.



--
Best regards
Leo Heuser

Followup to newsgroup only please.