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.