Option Explicit
Option Compare Text
Sub Bouton1_Cliquer()
Dim NbLig&, DLDest&, i&
Dim Ws As Worksheet
Application.ScreenUpdating = False
For Each Ws In Worksheets
If Ws.Name <> "LULU" Then
NbLig = Ws.Cells(Columns(1).Cells.Count, 8).End(xlUp).Row
For i = 2 To NbLig
If Ws.Range("H" & i).Value = "x" Then
DLDest = Worksheets("LULU").Cells(Columns(1).Cells.Count, 8).End(xlUp).Row + 1
Ws.Cells(i, 8).EntireRow.Copy
Sheets("LULU").Range("A" & DLDest).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
End If
Next
End If...