F
forcast
I have this code and it is working very well when I fill cells manually
Private Sub Worksheet_Change(ByVal Target As Range)
If Selection.Count > 1 Then Exit Sub
If Not Intersect(Target, Columns("L:L")) Is Nothing Then
If Target <= 0 Or Not IsNumeric(Target) Then Exit Sub
(If Target > Target.Offset(0, -10) Then Target.Offset(0, 3) =
Target.Offset(0, 3) + Target.Offset(0, -9
(If Target < Target.Offset(0, -10) Then Target.Offset(0, 4) =
Target.Offset(0, 4) + Target.Offset(0, -9
( If Target = Target.Offset(0, -10) Then Target.Offset(0, 5) =
Target.Offset(0, 5) + Target.Offset(0, -9
End If
End Sub
But when I use auto fill for cells or if you make for example L7 = F4 and I
fill F4 with any number say 10 I can see number 10 automatically on L7 but no
result on Q,P,O which mean the code is not respond , how can I make the code
work with the auto fill.
I remember Dave Peterson has solved a problem similar to this one any one
can help.
Thank you.
Forcast
Private Sub Worksheet_Change(ByVal Target As Range)
If Selection.Count > 1 Then Exit Sub
If Not Intersect(Target, Columns("L:L")) Is Nothing Then
If Target <= 0 Or Not IsNumeric(Target) Then Exit Sub
(If Target > Target.Offset(0, -10) Then Target.Offset(0, 3) =
Target.Offset(0, 3) + Target.Offset(0, -9
(If Target < Target.Offset(0, -10) Then Target.Offset(0, 4) =
Target.Offset(0, 4) + Target.Offset(0, -9
( If Target = Target.Offset(0, -10) Then Target.Offset(0, 5) =
Target.Offset(0, 5) + Target.Offset(0, -9
End If
End Sub
But when I use auto fill for cells or if you make for example L7 = F4 and I
fill F4 with any number say 10 I can see number 10 automatically on L7 but no
result on Q,P,O which mean the code is not respond , how can I make the code
work with the auto fill.
I remember Dave Peterson has solved a problem similar to this one any one
can help.
Thank you.
Forcast