Have a look at PivotTables and/or OlapCubes
..
keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"noelboland" wrote:

Dear All,

I had a problem where we down loaded a hugh amount of sales info
relating to a customer, from as400 into Excel.

The problem was different products were all sorted and split to
months, and I need to extract the totals from a 7000 line spreadsheet.

Whilst trying to do this task our sales manager said it would also be
very useful if as well as sorting the data, we could also highlight
the total in a different colour.

Help please.

info looks like
ord qty ord value sales
qty
sales value
2
3
5
7
11
total

above * 7000 lines.

Many Thanks
Noel