Bonjour,
Une piste :
Sub Test()
Dim FeUtil As Worksheet
Dim FeBD As Worksheet
Dim PlgUtil As Range
Dim PlgBD As Range
Dim CelUtil As Range
Dim CelBD As Range
Dim Lig As Long
Dim Message As String
Set FeUtil = Worksheets("Utilisateurs")
Set FeBD = Worksheets("BD_CLMT")
With FeBD: Set PlgBD = .Range(.Cells(2, 10), .Cells(.Rows.Count, 10).End(xlUp)): End With
With FeUtil: Set PlgUtil = .Range(.Cells(2, 8), .Cells(.Rows.Count, 8).End(xlUp)): End With
For Each CelBD In PlgBD
Set CelUtil = PlgUtil.Find(CelBD.Value, , xlValues, xlWhole)
If CelUtil Is Nothing Then
Lig = FeUtil.Cells(Rows.Count, 8).End(xlUp).Row + 1
FeUtil.Cells(Lig, 8).Value = CelBD.Value
FeUtil.Cells(Lig, 7).Value = CelBD.Offset(, -4).Value
Message = Message & "'" & CelBD.Value & "' pour le point de vente '" & CelBD.Offset(, -4).Value & "'" & vbCrLf
End If
Next CelBD
If Message <> "" Then MsgBox "Le ou les vendeurs ci-dessous ont été ajoutés à la liste : " & vbCrLf & Message
End Sub