Create Cumulative Total 1

[CindiN]

Hi,
I have a spreadsheet(Sheet 1) that substracts a Budget total from the $'s spent(Sheet 2) to get the Budget Remaining. Each time a new $ amount is spent(Sheet 2), the cell(in Sheet 2), deletes the old amount spent with the new (which is what I want it to do), therefore giving me a Budget Remaining(Sheet 1) that does not include the 1st amount spent. This is the problem.

Soooo, I tried creating another spreadsheet(Sheet 3) that copies the $'s spent(Sheet 2)in a column. How would I have(Sheet 3)jump to a new row when new $'s are spent(keeping the 1st $ spent in tact on row 1), so I could just use that column's cell reference in my formula to get the YTD Budget Remaining (on Sheet 1)? Also Sheet 3 would keep a running total from each new column entry, showing a Balance Remaining.

Hope this makes sense.
Thank you,
CindiN

 

[DaleWatson123321]

CindiN,

Your "scenario" doesn't sound difficult. However, to "get things exact", it is probably better for you and would-be contributors if you would offer to send the actual file.

If need be, you could replace sensitive data with "dummy data".

This approach will probably end up saving time for everyone.

If you decide this is a reasonable approach, I'd be willing to help, and get the file back to you very shortly.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[CindiN]

Hi Dale,

I really appreciate your help, I have e-mailed the workbook to you. Let me know if you need me to explain anything else.

Thanks,
CindiN