Code for Running Total Using only 2 cells

[navdad]

Not sure if this is possible, I'm assuming it can be done with VBA, but I don't know VBA. I'm trying to create a spreadsheet that uses one cell to enter a dollar amount and stores the amount entered in another cell. But I would like the input cell be zero after each entry, and the cell storing the amounts to keep a running total. Please help Thanks

[arlu1201]

It will be good if you attach a sample file.

[navdad]

Problem solved everything working perfectly.. I'd like to thank Richard for the first part of the code. The second part took some trial and error but I final got it working. So I'm posting the code in case someone else comes across the same problem.

Please Login or Register  to view this content.

[krcron]

OK, I was looking for the answer to this exact question. Problem is, I don't know how to use this answer as given. Is this a macro? How do I incorporate it?
Thanks

[prakashananth]

Hello

how will the macro for the below scenario look like? Also, attached the sample spreadsheet, need help on the MTDValues sheet.

Date a b c d e
7/1/2013 $12.00 $54.00 $32.00 $48.00 $56.00

The first cell (range "A") is date and other cells (range "B" to "F" - this may further be required to extend) are sales values for the date. Now there will values falling every day underneath this for the remaining month, and the values should have cumulative values generated on the daily basis. For the 1st day of the month the sales value and cumulative value would be the same, now from the 2nd day of the month on-wards the value should add up to its preceding days cumulative value in each cell. How to go about it. Any help would be greatly appreciated.

Thanks.