SORTING DATA IN TABLES
 

I havd a spreadsheet which has a number of tables that I need to sort. Each
table fetches details from a seperate sheet and I need each of the tables to
be sorted into order. The trouble is that when I sort one table and go to
sort the next I have to re-select the options of how the table is sorted, if
I then return to the first table because of changes in values and I want to
resort I have to enter the option again. Is there a way in which I can fix
the sort criteria to each table to save me doing this every time.

SORTING DATA IN TABLES
 

Either set up a sort-by list for each table in ToolsOptionsCustom Lists

Or record a macro for sorting each.


Gord Dibben MS Excel MVP

On Thu, 5 Nov 2009 08:36:02 -0800, Big Trev
wrote:

I havd a spreadsheet which has a number of tables that I need to sort. Each
table fetches details from a seperate sheet and I need each of the tables to
be sorted into order. The trouble is that when I sort one table and go to
sort the next I have to re-select the options of how the table is sorted, if
I then return to the first table because of changes in values and I want to
resort I have to enter the option again. Is there a way in which I can fix
the sort criteria to each table to save me doing this every time.