Adding running total macro

[agzil]

Hello All,

I want to modify this code to add a running total of column A on column B rows every time I add a value on column A. Cell B2 has already been set to a specific value. So I would like the code to start adding B2+A3 instead of A2+B2. I'm tucking this to a button.
Screen Shot 2016-04-15 at 1.09.45 PM.png

Please Login or Register  to view this content.

Thank you!

[djbomaha]

Hi agzil,

Here is some code that adds a formula in the cells in Column B to keep a running total, starting with Range B3. If you insert it outside of your "For Coin - Next Coin" loop, it should work.

Please Login or Register  to view this content.

Hope that helps,

Dan

[agzil]

Hi agzil,

Here is some code that adds a formula in the cells in Column B to keep a running total, starting with Range B3. If you insert it outside of your "For Coin - Next Coin" loop, it should work.

Please Login or Register  to view this content.

Hope that helps,

Dan

Dan! Thank you so much! I'm very new to all this and I've been stuck on this problem for quite some time now..So basically what you did is set the formula for the range. Can you please explain line three in more detail?

[TMS]

No loop necessary.

Please Login or Register  to view this content.

Change the sheet reference as required.

[agzil]

No loop necessary.

Please Login or Register  to view this content.

Change the sheet reference as required.

Thank you TMS, for the reply! I tried the code and its working properly but its adding from B2 and getting the header. How do you set it so the starting row is at 3?

[TMS]

Please Login or Register  to view this content.

[agzil]

I appreciate it so much Trevor!

[TMS]

You're welcome. Thanks for the rep.