Sorting

Hi Ras, thanks for your query. I think your first port of call would be to set up some custom views so you can sort and hide the relevant material and then snap to the dynamically updated information everytime you need it by selecting your custom view. If you want a more sophisticated structural change to occur in the arrangement of fields in the table you could either use the spreadsheet as the basis for a database query or write some code to complete re-order the sheet according to your criteria.

Hope this helps,

Anthony