Excel ?

[sdc1234]

I have 2 seperate fields, daily and cumulative, I am trying to put a # in the daily and it will add on the the cumulative... any thoughts...

 

[jmthompson]

so every time you override daily, you want cumulative to add the new number to it's running total?

 

[sdc1234]

thats exactly what I am trying to do

thx

 

[jmthompson]

I think you will need a macro to do this. It seems dangerous, though, what if someone enters a wrong value somewhere along the line and doesn't realize it right away. your cumulative is wrong forever.

At the very least, do not automate the running of the macro. This code assumes your daily is in A1 and your Cumulative is in B1

Sub UpdateSum()
Dim MySum As Long
MySum = Range("B1").Value
Range("B1") = MySum + Range("A1").Value
End Sub

 

[sdc1234]

thank you, I have 1 more for u may sound a little beginner like I havent used this program in a while bu the ? is does this code go into VB I believe it does right...

thx

 

[jmthompson]

It does, Alt+F11 to launch the VB Editor, click on your workbook name at the left, then insert a module. Paste the code in, make any necessary changes and then close the window.

I always recommend doing this in a copy of your file before running the macro. You cannot undo anything done by a macro, and some unexpected things can happen.

 

[sdc1234]

is there any way to do this without running a macro?


thx

 

[jmthompson]

Formula based? Not that I'm aware of.
You could always copy the value in daily and paste special-> Add to cumulative.

 

[sdc1234]

I tried doing the macro but for some reason it does not work is there something else I need to do after I insert the code

thx

 

[sdc1234]

I figured out the script but I want it to run automatically instead of hitting the macro button