Using WinXP Pro and MSOffice 2003 Pro
Col D has customer name
Col E has customer location
Col G has customer amounts
There can be many locations to a customer name, and many line items to
the combination CustName and CustLocation

I need to read Col D, then first location of Col E which may have many
line items, then I need to do a sum of the numbers in col G that belong
to col D and col E combined.

I want to repeat this thru a 3000+ spread sheet, breaking out a total
for each Customer Name with each of it's locations.

Example
Col D Col E Col G
ABC Co Chicago 22.22
ABC Co Chicago 8.00
ABC Co Chicago 15.00 end of location-get total for G
ABC Co New York City 2.22
ABC Co New York City 18.00
ABC Co New York City 215.00 end of location-get total for G
ABC Co Miami 22.22
ABC Co Miami 8.00
ABC Co Miami 15.00
ABC Co Miami 22.22
ABC Co Miami 8.00
ABC Co Miami 15.00
Bats and Balls Springfield 55.55 end of name/location-get total for G
Bats and Balls Los Angeles 44.44 end of name/location-get total for G

etc etc, where the code recognizes ABC Co in chicago, totals the Chicago
numbers, then recognizes ABC Co in NYC, totals, gets ABC Co Miami,
totals, Recognizes Bats and Balls, Springfield, totals, Bats and Balls
Los Angeles, totals, etc etc.

Do I need to code this or will filters in Excel do this job. Being a
newbie here, I would appreciate any help you can give, as always.
Joanne