Ras has attended:
Excel Introduction course
Excel Intermediate course
Excel Advanced course
Sorting
Hi my question is relating to sorting data in Excel 2003.
I have a table which shows various complaint catagories on the left hand side and monthly volumes in each column, I want to show the latest column from the highest volumed complaint volume at the top and then I want the previous columns to show the volumes for this catagory in previous months. Any idea on how i could do this please?
Ras
RE: 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
