Budget vs Spend Reporting

[pearlbaby_us]

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!

 

[Don Guillett]

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.

 

[Herbert Seidenberg]

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

 

[Ashish Mathur]

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