Sub Button58_Click()
If Not Intersect(Target, Range("B3:I17")) Is Nothing Then
On Error Resume Next
Application.EnableEvents = False
Target.Offset(19).Value = Target.Offset(19).Value + Target.Value
Target.Offset(37).Value = Target.Offset(37).Value + Target.Value
Target.Offset(55).Value = Target.Offset(55).Value + Target.Value
Application.EnableEvents = True
End If
End Sub
this is what I currently have for a tracker I am using at work. when I type a number into cell b3 it rolls down to b22 and b40 and keeps a running total but not b58. can someone please help me fix this.
Bookmarks