re,
à tester,
Sub concaténer_références()
Dim c As Range, n As Integer
Sheets("Sheet1").ListObjects("Table1").Range.AutoFilter Field:=3, Criteria1:="C"
With Sheets("Sheet1").ListObjects(1).ListColumns("Référence")
For Each c In .DataBodyRange.SpecialCells(xlCellTypeVisible)
Sheets("Sheet2").Cells(10, 2 + n) = c.Value
n = n + 1
Next c
End With
End Sub
ou bien,
Sub concaténer_références2()
Dim c As Range, t As String
Sheets("Sheet1").ListObjects("Table1").Range.AutoFilter Field:=3, Criteria1:="C"
With Sheets("Sheet1").ListObjects(1).ListColumns("Référence")
For Each c In .DataBodyRange.SpecialCells(xlCellTypeVisible)
t = t & c.Value & ", "
Next c
End With
Sheets("Sheet2").Range("B10") = t
End Sub