Sub Clients()
Dim TabloC, TabloF, TabloFC, i As Long, Concat As String
With Worksheets("Suivi commande")
TabloFC = .Range("B2:D" & .Range("B" & Rows.Count).End(xlUp).Row)
End With
With Worksheets("AR fournisseur")
TabloF = .Range("A2:A" & .Range("A" & Rows.Count).End(xlUp).Row)
ReDim TabloC(1 To UBound(TabloF))
For i = LBound(TabloF) To UBound(TabloF)
For j = LBound(TabloFC) To UBound(TabloFC)
If TabloF(i, 1) = TabloFC(j, 3) Then TabloC(i) = TabloC(i) & IIf(Len(TabloC(i)) > 0, " / ", "") & TabloFC(j, 1)
Next
Next
.Range("F2").Resize(UBound(TabloC, 1), 1) = Application.Transpose(TabloC)
End With
End Sub