A worksheet is populated with several columns of sales data, starting at row 25. Above this is a summary area.

One of the columns is 'category' and another is 'sales'. There could be a range in number of categories as each time the report is run,it might be different. There will be a minimum of 1 category and maximum of say 20. Individual item sales are then listed in rows, with each item having a category assigned to it.

In the summary area I would like to list each category once, along with a subtotal all items for that category from the sales column.

To carry it one step further, I would like to list these categories in descending order based on the sales total.

Any ideas?

Thanks in advance,
Denny