أخى الفاضل
جرب هذا الكود
Private Sub Worksheet_Change(ByVal Target As Range)
Dim LR As Integer
LR = Cells(Rows.Count, "I").End(xlUp).Row
If Not Intersect(Target, Range("I5:I" & LR)) Is Nothing Then
If Target.Count > 1 Then Exit Sub
If Target = "سداد - خالص" And Target.Offset(0, -1) <> 0 Then
Target.Offset(0, 1) = Target.Offset(0, -1)
Target.Offset(0, -1) = 0
Target.Offset(0, -2) = Target.Offset(0, -3)
End If
End If
End Sub
مديونيات1.rar