Calculating pallet movement

Hi @Mitch.Birlea

You can try with this code,
It only considers changes in columns I, J, K. but I can see in your book columns L, and M used for the same purpose.
If you need them, then you can change the code acordingly

Private Sub Worksheet_Change(ByVal Target As Range)
Dim tRow As Long
tRow = Target.Row

    If Not Intersect(Target, Columns("I:K")) Is Nothing Then
        If Cells(tRow, 8).Value <= 0 Then
            If Cells(tRow, 8).Value < 0 Then
                MsgBox "Negative balance in line : " & tRow
            End If
            Rows(tRow).EntireRow.Hidden = True
        End If
    End If
End Sub