Bonsoir,
Une possibilité /
Le code :
Sub Suppr_Niv_Inf()
Dim DerLig As Long
Dim I As Long
Application.ScreenUpdating = False
DerLig = Cells(Rows.Count, "H").End(xlUp).Row
For I = 1 To 6
With Range(Cells(2, I), Cells(DerLig, I))
If Application.CountA(.Value) > 0 Then .TextToColumns Destination:=Cells(2, I)
End With
Next I
Columns("A:A").Insert Shift:=xlToRight
With Range("A2")
.FormulaR1C1 = "=SUM(RC[1]:RC[6])-SUM(R[+1]C[1]:R[+1]C[6])"
.AutoFill Destination:=.Resize(DerLig - 1), Type:=xlFillDefault
.Resize(DerLig - 1).Value = .Resize(DerLig - 1).Value
End With
For I = DerLig To 2 Step -1
If Cells(I, 1).Value = -1 Then
Rows(I).Delete
End If
Next I
Columns(1).Delete
End Sub
Le fichier :
Bonne nuit