Bonjour,
Une proposition à étudier.
Cdlt.
Public Sub Clean_Data()
Dim tbl, Arr()
Dim I As Long, k As Long
With ActiveSheet
tbl = .Cells(1).CurrentRegion
.Cells(1).CurrentRegion.Offset(1).ClearContents
For I = 2 To UBound(tbl)
Select Case True
Case tbl(I, 2) Like "NUM*" Or tbl(I, 2) Like "REF*":
ReDim Preserve Arr(2, k + 1)
Arr(0, k) = tbl(I, 1)
Arr(1, k) = tbl(I, 2)
k = k + 1
Case Else:
End Select
Next I
.Cells(2, 1).Resize(UBound(Arr, 2), 2).Value = Application.Transpose(Arr)
End With
End Sub