How to accumulate same cell entries

[nousibona]

I need to create a spreadsheet where the cells I enter daily figures accumulate from their last values and not be replaced by the new values. E.g. Current value on cell A1 is 5. When I enter 5 on cell A1 it should accumulate to 10 and not be replaced with 5 again. I tried doing this with worksheets functions but I end up with a recursive formula. Any idea on doing this on the same sheet?

Please I really need help with this problem.

[nousibona]

Hi,
I have been trying to create a daily reporting spreadheet where daily entries are made. However the new entries I enter replaces the old entries. Is there a function to make the cell accmulate from the previous value instead of being replaced. E.g. Previous value fro cell A1 is 10. When I enter 2 in cell A1 it should be accumulated to 12 and not be replaced with 2. So cell Ai should read 12.

Please need help on this urgently?

[shg]

It's easy enough with VBA, but comes at the expense of eliminating Undo, which I think is a high price to pay.

It's been asked and answered many times. If you still want to do it and don't find it in a forum search, please post in the Programming forum.

[shg]

Threads merged.

I see you have already posted in the programming forum.

Please read and acknowledge our Forum Rules, and then I or someone else will help.

[nousibona]

Thankyou very much I just read through the Forum Rules. Accept my apologies for the two threads I posted.

Anyone to help??

[shg]

Maybe like this. Code goes in the appropriate sheet module. Adjust the range as desired.

Please Login or Register  to view this content.

[nousibona]

The code worked 100%. Even on the bigger table the range is all that need to be changed. Thanks SHG and others. I hope to learn alot from you through this site.

Thankyou very much for your expertise and the much needed help.

Very much appreciated.