Group data from excel query - Office 2007

[jeffm777]

I have a spreadsheet that shows sales information for the 3rd quarter of 2012. Each row of data shows a customer number, customer name, address, city, state zip, and sales total for each invoice. What I need to do is group this data by customer number and show the total sales for each customer. I can do this in a pivot table but I need to retain the customer information in each row of data so I can print address labels. We want to send Christmas cards to our 100 best customers.

Thanks in advance for any help. I'm trying to avoid building a Crystal Report if at all possible.

 

[xlhelp]

Sort it by customer number and use Subtotal feature of Excel (Under Data Tab). Compress the details. Select all. Under Find and Select choose GoTO Special (Home Tab). Choose Visible Cells Only. Copy. Paste in a blank area or blank spreadsheet.


Avoid Hangovers. Stay drunk.