Filter/sort question

[ivwshane]

I have a worksheet that has column labels, data, and data totals.

I'd like to be able to do something similar to autofilter but have it only sort the data and leave the data totals in place.

So it would go from this:

Data label 1
7
9
10
8
Total 34

To this:
Data label 1
10
9
8
7
Total 34


And to complicate things there are multiple column labels and each row must stay intact when sorted.

(I'm using excel 2003 but it seems like excel 2007 has this functionality).

[Portuga]

You could do a pivot table with the data. It allows sorting of fields and the totals always stays at the end