Excel need cell to update

[malverd]

Hi,

I have a spreadsheet that has a cell with a value that constantly changes. I also want to have another cell that will keep a cumulative total of the first cell.

Example:
cell A1 has a value of 1
cell C2 would now have a value of 1
cell A1 value changes to 2
cell C2 would now have a value of 3

I'm sure it's easy but I can't for the life of me figure it out.

Thanks

 

[fishtears]

1. Right click the relevant sheet name tab in workbook1 and choose "View Code".
2. Copy and Paste the code below into the main right hand pane that opens at step 1.
3. Close the Visual Basic window (after editing the code for your workbook names).
4. Try making some changes in Cell A1 in workbook1

Private Sub Worksheet_Change(ByVal Target As Range)
Dim n As Long
If Target.Rows.Count = 1 And Target.Columns.Count = 1 And Target.Row = 1 And Target.Column = 1 Then
n = Range("C2").Value
Range("C2") = n + Target.Value
End If
End Sub