Sub Transfert_BLV2()
Dim NomFeuilles, i As Byte, j As Long, a As Range
NomsFeuilles = Array("BLV") ' ici mettre le nom des feuilles concernées
For i = 0 To UBound(NomsFeuilles)
With Sheets(NomsFeuilles(i))
For j = 14 To 88
If Not .Cells(j, "C") Like "Code" Then
Set a = Sheets("SAISIE").Range("A65536").End(xlUp)(2)
.Cells(j, "B").Resize(, 11).Copy a
a.Offset(, (IIf(.Cells(j, "I") < 0, 10, 12))) = .Cells(j, "I")
Set a = Nothing
End If
Next j
End With
Next i
End Sub