Avec la suppression de la liste en ammont
Option Explicit
Dim i, y As Integer
Sub generer_bordereau()
If ActiveSheet.Cells(7, 18) = "" Then
Exit Sub
Else
ActiveSheet.Range("C16:AD39").ClearContents
y = 16
For i = 2 To ActiveWorkbook.Sheets("LISTE PLANS").UsedRange.Rows.Count + 1
If ActiveWorkbook.Sheets("LISTE PLANS").Cells(i, 1) = ActiveWorkbook.Sheets("(01)").Cells(7, 18) Then
'N° Plan
ActiveWorkbook.Sheets("(01)").Cells(y, 4) = ActiveWorkbook.Sheets("LISTE PLANS").Cells(i, 3)
'Ind
ActiveWorkbook.Sheets("(01)").Cells(y, 6) = ActiveWorkbook.Sheets("LISTE PLANS").Cells(i, 2)
'Désignation
ActiveWorkbook.Sheets("(01)").Cells(y, 7) = ActiveWorkbook.Sheets("LISTE PLANS").Cells(i, 4)
y = y + 1
End If
Next
End If
End Sub