Direct Increment

Hi All,

I hope you are all doing fine. I have a problem. I don't know if anyone can help me with it. It is something that I may call Direct Increment. Actually, I have two cells, B2 and C2. I use B2 to enter figures every day. But I would like cell C2 to directly sum up the newly entered figure in B2 and the old figure of C2. That way C2's figure changes automatically to add the figure typed into B2. So, if I had 17 in C2, once I enter 2 into B2, C2 returns 19.

Is this possible?

Is this possible?

Only with VBA. And even then, I wouldn't recommend it. There would be no audit trail and you would have no way of knowing if you have entered a value more than once, or not at all.

Yes, it's possible. But only with VBA using a Worksheet Change Event handler monitoring cell B2. When cell B2 changes, the Event handler will fire and can add the contents of cell B2 to cell C2 and then clear cell B2.

Please Login or Register  to view this content.

With a bit more error checking ...

Please Login or Register  to view this content.

If that takes care of your original question, please choose Thread Tools from the menu link above and mark this thread as SOLVED.

Also, if you have not already done so, remember that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.