Option Explicit
Sub Copier_coller()
Dim a As Object, b As Object
With Application: .ScreenUpdating = False: .Calculation = xlManual: .EnableEvents = False: End With
Set a = Sheets("Extraction")
Set b = Sheets("liste finale")
b.Columns("a:h").Clear
With a
.Columns("f:f").SpecialCells(xlCellTypeVisible).SpecialCells(xlCellTypeConstants).Copy b.Range("a1")
.Columns("h:h").SpecialCells(xlCellTypeVisible).SpecialCells(xlCellTypeConstants).Copy b.Range("b1")
.Columns("g:g").SpecialCells(xlCellTypeVisible).SpecialCells(xlCellTypeConstants).Copy b.Range("c1")
.Columns("a:e").SpecialCells(xlCellTypeVisible).SpecialCells(xlCellTypeConstants).Copy b.Range("d1")
End With
Cells.EntireColumn.AutoFit
With Application: .EnableEvents = True: .Calculation = xlAutomatic: .ScreenUpdating = True: End With
End Sub