1. Copy the contents of the table to the clipboard.
2. Copy/paste values to another sheet
3. Sort the table on that other sheet.
You might like to record or write a macro to automate all of this.
Kees
Hi,
I have a block of excel data (Excel 2003) which contains client name, client a/c number, month and value.
I want to create a pivot with a/c number and client name for rows, months 1-12 as column heading and grand total for rows and columns.
So far, no problem, but I want the rows sorted not by a/c number or name, but by grand total of rows, so client with highest total for year is first in table, and client with lowest total is last.
Any ideas how to achieve this ?
Thanks for reading.

Chowhound
Comic Vine
GameFAQs
GameSpot
Giant Bomb
TechRepublic