With the help of the good people on this group I've been able to create
about 8 macros for my company. However, now I'm being asked to create
a macro that is way out of my league. Maybe this task is too big for a
macro. I have the following columns in my spreadsheet:

A=Part Number
B=Customer
C=Sales Order Number
D=Date
E=Quantity
F=Unit Price
G=Extended Price
H=Product Type

I need to take the last three years and separate the rows by customer
and then by part number, showing the total dollars booked for each
customer/part number for each quarter. So my new spreadsheet would to
look something like this:

QTR 1 QTR 2 QTR3
QTR4
CUSTOMER #1
PART #1 $ $ $
$
PART #2 $ $ $
$
PART #3 $ $ $
$
PART #4 $ $ $
$
PART #5 $ $ $
$
PART #6 $ $ $
$

CUSTOMER #2
PART #1 $ $ $
$
PART #2 $ $ $
$
PART #3 $ $ $
$
PART #4 $ $ $
$
PART #5 $ $ $
$
PART #6 $ $ $
$

CUSTOMER #3
PART #1 $ $ $
$
PART #2 $ $ $
$
PART #3 $ $ $
$
PART #4 $ $ $
$
PART #5 $ $ $
$
PART #6 $ $ $
$


CUSTOMER=Actual Customer Name
PART NUMBER=Actual Part Number

Some customers would have 2-3 parts while others might have 20.

Is this possible with a macro and is there anyone out there who could
help me with this? I can do a basic sort. But figuring out how to get
it to total up the separate part numbers for each quarter and place
this new information all on another page has got me LOST!

I appreciate any help.

Regards,
Tahrah