LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Finding top 20% of spend dollars in a column wjs81866 New Users to Excel 2 January 27th 09 06:26 AM
Create Monthly Spend Chart hals_left Excel Discussion (Misc queries) 4 August 20th 07 02:04 PM
How do I estimate the year spend if spend is $26000 as of May? Felicia Pickett Excel Worksheet Functions 4 June 20th 06 04:08 AM
Divide Monthly Sales Budget to Day Budget Benedikt Fridbjornsson Excel Worksheet Functions 2 January 10th 06 03:42 PM
Program to calculate how much I can afford to spend? Looking to start over Excel Discussion (Misc queries) 3 November 30th 05 10:12 PM


All times are GMT +1. The time now is 10:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"