Budget vs Spend Reporting
 

I have a big spreadsheet of purchases made on tab 1, on a second tab I want
to have a report that deducts what has been spent against the set budget. So
I have 1 line per account on the second tab and I want to say if there is a
line entered on the first tab with that account then I want the money
deducted from the budget listed on the second tab. Any help would be greatly
appreciated. Thanks!

Budget vs Spend Reporting
 

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You send a clear explanation of what you want
3. You send before/after examples and expected results.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"pearlbaby_us" wrote in message
...
I have a big spreadsheet of purchases made on tab 1, on a second tab I want
to have a report that deducts what has been spent against the set budget.
So
I have 1 line per account on the second tab and I want to say if there is
a
line entered on the first tab with that account then I want the money
deducted from the budget listed on the second tab. Any help would be
greatly
appreciated. Thanks!

Budget vs Spend Reporting
 

Excel 2007
Two ways:
Table (with formulas)
PivotTable (no formulas)
http://www.mediafire.com/file/jdjy0wmjn0m/10_04_09.xlsx

Budget vs Spend Reporting
 

Hi,

Not clear about your question. Could you mail me the file at
ask(at)ashishmathur(dot)com

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"pearlbaby_us" wrote in message
...
I have a big spreadsheet of purchases made on tab 1, on a second tab I
want
to have a report that deducts what has been spent against the set budget.
So
I have 1 line per account on the second tab and I want to say if there is
a
line entered on the first tab with that account then I want the money
deducted from the budget listed on the second tab. Any help would be
greatly
appreciated. Thanks!