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!

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!

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

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!