Voila,mon code fonctionne pour extraire des donnees d une feuille activite vers une autre feuille BLN sauf que je ne trouve pas pourquoi mes donnees sont decalées de 2 rangs sur la colonne B
Je ne trouve pas le pourquoi du comment
Sub Copier_Déc()
Dim DerLig As Long
Dim Lig As Integer
For Lig = 14 To 100
DerLig = Range("B1").End(xlDown).Row + 1
'DerLig cela me sert plus loin dans mon code
'-----------------------------------------------------------------------
'banlin
If Feuil1.Cells(Lig, 25) = "BLN" Or Feuil1.Cells(Lig, 26) = "BLN" Then
Worksheets("BLN").Rows(2).Insert Shift:=xlDown
'colonne A
Worksheets("BLN").Cells(1, 1) = Worksheets("Activité").Cells(4, 7)
'Colonne B
Worksheets("BLN").Cells(2, 2) = Worksheets("Activité").Cells(Lig, 2)
'Colonne C
Worksheets("BLN").Cells(2, 3) = Worksheets("Activité").Cells(Lig, 3)
'Colonne D
Worksheets("BLN").Cells(2, 4) = Worksheets("Activité").Cells(Lig, 4)
'Colonne S
Worksheets("BLN").Cells(2, 5) = Worksheets("Activité").Cells(Lig, 40)
'Colonne X
Worksheets("BLN").Cells(2, 6) = Worksheets("Activité").Cells(Lig, 24)
End If
If Feuil1.Cells(Lig, 27) = "BLN" Or Feuil1.Cells(Lig, 28) = "BLN" Then
Worksheets("BLN").Rows(2).Insert Shift:=xlDown
'Colonne A
Worksheets("BLN").Cells(1, 1) = Worksheets("Activité").Cells(4, 7)
'Colonne B
Worksheets("BLN").Cells(2, 2) = Worksheets("Activité").Cells(Lig, 2)
'Colonne C
Worksheets("BLN").Cells(2, 3) = Worksheets("Activité").Cells(Lig, 3)
'Colonne D
Worksheets("BLN").Cells(2, 4) = Worksheets("Activité").Cells(Lig, 4)
'Colonne S
Worksheets("BLN").Cells(2, 5) = Worksheets("Activité").Cells(Lig, 41)
'Colonne X
Worksheets("BLN").Cells(2, 6) = Worksheets("Activité").Cells(Lig, 24)
End If
If Feuil1.Cells(Lig, 29) = "BLN" Then
Worksheets("BLN").Rows(2).Insert Shift:=xlDown
'Colonne A
Worksheets("BLN").Cells(1, 1) = Worksheets("Activité").Cells(4, 7)
'Colonne B
Worksheets("BLN").Cells(2, 2) = Worksheets("Activité").Cells(Lig, 2)
'Colonne C
Worksheets("BLN").Cells(2, 3) = Worksheets("Activité").Cells(Lig, 3)
'Colonne D
Worksheets("BLN").Cells(2, 4) = Worksheets("Activité").Cells(Lig, 4)
'Colonne S
Worksheets("BLN").Cells(2, 5) = Worksheets("Activité").Cells(Lig, 42)
'Colonne X
Worksheets("BLN").Cells(2, 6) = Worksheets("Activité").Cells(Lig, 24)
End If
If Feuil1.Cells(Lig, 30) = "BLN" Then
Worksheets("BLN").Rows(2).Insert Shift:=xlDown
'Colonne A
Worksheets("BLN").Cells(1, 1) = Worksheets("Activité").Cells(4, 7)
'Colonne B
Worksheets("BLN").Cells(2, 2) = Worksheets("Activité").Cells(Lig, 2)
'Colonne C
Worksheets("BLN").Cells(2, 3) = Worksheets("Activité").Cells(Lig, 3)
'Colonne D
Worksheets("BLN").Cells(2, 4) = Worksheets("Activité").Cells(Lig, 4)
'Colonne S
Worksheets("BLN").Cells(2, 5) = Worksheets("Activité").Cells(Lig, 43)
'Colonne X
Worksheets("BLN").Cells(2, 6) = Worksheets("Activité").Cells(Lig, 24)
End If