Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("N17:N42")) Is Nothing Then
If Target.Value = "Ok" Then
With Sheets("GestionStockSorties")
LigVide = .Range("A65536").End(xlUp).Row + 1
.Cells(LigVide, 1) = Target.Offset(0, -12).Value
.Cells(LigVide, 2) = Target.Offset(0, -10).Value
.Cells(LigVide, 3) = Target.Offset(0, -1).Value
End With
End If
End If
End Sub