Cell value changes

[Skydave2805]

Hi all, first time poster and bit of an Excel newbie so be gentle.

I have a nice easy spreadsheet that calculates colleagues commission for them. E8 = C8*D8.
The trouble is, sometimes the value of C8 can sometimes change which has a knock on effect of the value of E8.

Is there a way of keeping the running total in E8 unaffected by the change of the value in C8?

Thanks in advance

 

[dreid1011]

Not with a formula, but you could achieve the result with some VBA each time C8 changes. Could you provide an example of the values for C8 and D8 and how you want E8 to track that?

If you are not opposed to VBA, try this in the worksheet module and change "Sheet1" to the name of your sheet:

Private Sub Worksheet_Change(ByVal Target As Range)
With Worksheets("Sheet1")
    If Not Intersect(Target, Range("C8")) Is Nothing Then
        .Range("E8").Value = .Range("E8").Value + .Range("C8").Value * .Range("D8").Value
    End If
End With
End Sub

 

[Skydave2805]

Thanks for the reply, but I'm not that advanced on Excel and thought a simple formula could sort the issue.
If you can help me through it though I would really appreciate it. I copied the code from the above and placed it in a module but I'm stuck from there.
Also, would it be possible to apply the code to all cells in the C column. I've attached a screen grab of worksheet.
Column C is the commission price which is multiplied by a value in D but the any of the values in C may change from time to time.