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]

For the reasons mentioned previously, I strongly discourage this, but this is the code you need for it to run automatically.

This code is installed differently, right click on your sheet/tab name, click View Code. paste this code there, close the VBE window.

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Intersect(Range("A:A"), Target) Is Nothing Then Exit Sub
Dim MySum As Long
MySum = Range("B1").Value
Range("B1") = MySum + Range("A1").Value

End Sub

 

[sdc1234]

Range("A:A"), do I need to change this or leave it

thx

 

[jmthompson]

Where is your "daily" cell, where is your "cumulative" cell? Column and row

 

[sdc1234]

Daily = G15
Running = H27

 

[jmthompson]

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Intersect(Range("G:G"), Target) Is Nothing Then Exit Sub
Dim MySum As Long
MySum = Range("H27").Value
Range("H27") = MySum + Range("G15").Value

End Sub

</pre>

 

[MrKowz]

This will do what you need, to use it, right click on the sheet tab you want it to run on and click view code. Then copy/paste the following code into that window:

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("G15")) Is Nothing Then
    Range("H27").Value = Range("H27").Value + Target.Value
End If
End Sub

 

[sdc1234]

it worked thank u, when I click on the cell it adds it again even after I have typed it in: say I had the daily on 5 and it added 5 to the running which is fine but the next guy anly has 4 and clicks on the daily, it added a total of 9, is there any way to prevent this..

 

[MrKowz]

it worked thank u, when I click on the cell it adds it again even after I have typed it in: say I had the daily on 5 and it added 5 to the running which is fine but the next guy anly has 4 and clicks on the daily, it added a total of 9, is there any way to prevent this..

Use the Worksheet_Change macro I provided. The selection_change will fire every time you move your cursor over column G.

 

[sdc1234]

thank u it worked

 

[sdc1234]

I want to merge specific cells on 3 different spreadsheets to 1 main spreadsheet, I have tried consolidate but still not working any thoughts...

thx