Calulating a running total based on date

**prince-aric** · 09-18-2010, 01:05 PM

I mad a prior post that didn't so much as even get a suggestion or relevant comment, so I'm trying to give it one last try hoping that maybe I just put it in the wrong forum.

I've been trying to figure out, either via lookup, an if condition, a macro of some sort or something along those lines, but they all seem to point in the same direction. Basically that I need to have a spread on that same worksheet with different dates.
I haven't used excel in a while and so the things that I used to know how to do have gotten rusty. (bear in mind I have to deal with 2003, and I'm used to the more user friendly 2010)

Here's what I had in mind.

1- A running total of the "Cash" (C11), "Gross"(C12), and "EFT"(C13) by date summed up at the end of the month or set data period. (my main issue)

Let me explain this part better. All the formulas and things require a list of data located either on the sheet or via another workbook. Is there a way I can set a condition to look at the current 'now' date and the value that is input into those cells can be taken from a total located somewhere else on the sheet (to be determined), saved, and when opened again continue on using the data from the same cell? (this is where I get hung up)

*** Anything after this is basically the same condition as above, just using different cells.***

2- The middle section where cash and gross appear, I'd like to be able to take the running total from 1, and have it decrease from the set goal/cell that I could probably create somewhere on the table.

3- Lastly, It would be nice to have the same type of formula from 1 to add the set, show, and close numbers as a running total by date.

I'm hoping for some good input, or at least a direction to go since it feels like I'm starting from scratch again.

Thanks guys

**Richard Buttrey** · 09-18-2010, 01:34 PM

Hi,

Are you wanting to use your layout as a data entry form to capture daily inputs which you subsequently want to analyse and report on?

If so with your current layout you're going to need some VBA macro code to update a table of values based on your form inputs. For a relative beginner this is non trivial.

Can I suggest you look at the Excel standard menu item Data--> Form functionality first. This will do all the data capture work for you and once you have a list you can then use normal functions to analyse it.

HTH

**prince-aric** · 09-18-2010, 01:39 PM

Yeah, that seems pretty close to what I need. It is a data entry kind of document. Basically the managers will all be sending this in, and I'm trying to keep a running total of their production by day. Once I have that in place, I won't have to add up each individual save to my master sheet, but instead just have to use the last one of the month to do it, and even then I can import them into another document once I'm at that point.
I will try to tinker around with it, and maybe see if there are any examples anywhere.

**prince-aric** · 09-19-2010, 05:39 PM

If anyone could offer some help for this (VBA coding), it would be appreciated. I'm doing what I can to refresh myself, but it may just take one of you excel kings 5 minutes to do it.

**prince-aric** · 09-19-2010, 06:18 PM

So I've pretty much narrowed it down to what it is I think I need. I just need a way for the data input that day to carry over as the "new" total when the document is saved(or a button is pressed, etc) so that my formulas can take it from the new total that was created the previous day with my formulas. Any ideas?