Bonjour,
Un exemple avec les données mises sous forme de tableaux structurés.
Cdlt.
Public Sub CopyData()
Dim lo As ListObject, lo2 As ListObject, r As Range, Cell As Range
Set lo = Range("t_Data").ListObject
Set lo2 = Range("t_Résultat").ListObject
With lo2
If Not .DataBodyRange Is Nothing Then .DataBodyRange.Delete
Set r = .InsertRowRange.Cells(1)
End With
For Each Cell In lo.ListColumns(2).DataBodyRange
If Cell.Value = VBA.Date Then
With r
.Value = Cell.Offset(, -1).Value
.Offset(, 1).Value = Cell.Offset(, 1).Value
Set r = .Offset(1)
End With
End If
Next Cell
End Sub