Dim j As Integer
Dim LastRow As Integer
Dim DerniereLigne As Integer
Sub recopie()
Application.ScreenUpdating = False
For j = 2 To 4
Sheets(j).Select
LastRow = Range("C300").End(xlUp).Row
For i = LastRow To 6 Step -1
Sheets(j).Select
Rows(i).Select
Selection.Delete shift:=xlUp
Next i
Sheets("Suivi").Select
DerniereLigne = Range("A300").End(xlUp).Row
For k = 5 To DerniereLigne
Sheets("Suivi").Select
If Sheets(j).Name = Cells(k, 3).Value Then
Rows(k).Select
Selection.Copy
Sheets(j).Select
LastRow = Range("A300").End(xlUp).Row + 1
Cells(LastRow, 1).Select
ActiveSheet.Paste
End If
Next k
Next j
Sheets("Suivi").Select
Application.CutCopyMode = True
Application.ScreenUpdating = True
End Sub
Partager