Bonjour,
Un début de réponse.
Cdlt.
Public Sub Copydata()
Dim ws As Worksheet, ws2 As Worksheet, rng As Range, lRow As Long
Set ws = Worksheets("R?el M-1 2019 ")
Set ws2 = Worksheets("Rubriques")
With ws
lRow = .Cells(.Rows.Count, 9).End(xlUp).Row
Set rng = .Cells(2, 9).Resize(lRow - 1, 4)
End With
With ws2
lRow = .Cells(.Rows.Count, 1).End(xlUp).Row + 1
.Cells(lRow, 1).Resize(rng.Rows.Count, rng.Columns.Count) = rng.Value
.Cells(1).CurrentRegion.RemoveDuplicates Columns:=Array(1, 2, 3, 4), Header:=xlYes
.Cells(1).CurrentRegion.Borders.Weight = xlThin
End With
End Sub