SORTING DATA IN TABLES

  • Thread starter Thread starter Big Trev
  • Start date Start date
B

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.
 
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
 
Back
Top