That's awesome. Thank you so much!

"Bernard Liengme" wrote:

You can change this to give Count, Sum, Average, etc
See one of the links in my first message
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"jeb" wrote in message
...
I've never used a pivot chart for Excel. I have used them in Access
though.
The only hang-up with this pivot chart is that it gives me the total
NUMBER
of transactions, not the TOTAL SPEND AMOUNT (JOE BROWN LOGISTICS
$12,000<total of 8 thransactions). Any further advice?

"Roger Govier" wrote:

Hi

Use a Pivot Table.
Place your cursor within your source tableDataPivot Table Finish
On the new sheet where the Pivot Table skeleton appears
Drag Cardholder to Row area
Drag Department to Row area
Drag Amount to Data Area

--
Regards
Roger Govier

"jeb" wrote in message
...
Hi, I am hoping that someone with a little more excel experience can
help
me.
I compile a dispersable billing statement for our company execs for our
corporate card use.

I am able to download the report in excel format. I am losing a lot of
time
filtering card users, running a sum for transactions, & copying &
pasting
to
a new sheet.

For example:
CARDHOLDER DEPARTMENT AMOUNT
Joe Brown Logistics $999.99
Joe Brown Logistics $698.23
Joe Brown Logistics ($33.21)
Joe Bruce Marketing $581.98
Joe Bruce Marketing $11.74

This excel spreadsheet contains approx. 300 separate cardholders and
approx.
3500 separate transactions. I want to reduce it down to 1 instance of
cardholder's name, department, & transaction total. Any help?