Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Billing Statement Help
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Billing Statement Help | Excel Discussion (Misc queries) | |||
Frequency of Billing | Excel Worksheet Functions | |||
Formula for billing water | Excel Discussion (Misc queries) | |||
customer billing | New Users to Excel | |||
Where can I find a Billing Statement Template for Word or Excel? | New Users to Excel |