SORTING DATA IN TABLES

[Big Trev]

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.

 

[Gord Dibben]

Either set up a sort-by list for each table in Tools>Options>Custom Lists

Or record a macro for sorting each.


Gord Dibben MS Excel MVP