Billing Statement Help
 

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?

Billing Statement Help
 

Pls post in ONLY one group.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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?

Billing Statement Help
 

see response to your posting in other group.
Please do not multipost, it wastes a lot of peoples time.

--
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?

Billing Statement Help
 

Please don't multipost. If the question appears in more than one group we
will usually assume that it has been answered elsewhere.
--
David Biddulph

"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?