Bonjour,
Un début de réponse !?
Cdlt.
Public Sub UpdateData()
Dim lastRow As Long, lRow As Long, n
Application.ScreenUpdating = False
With ActiveSheet
lastRow = .Cells(.Rows.Count, 1).End(xlUp).Row
For lRow = 5 To lastRow Step 2
On Error Resume Next
n = Application.Match(.Cells(lRow, 2), .Cells(3, 4).Resize(, 11), 0)
If Not IsError(n) Then
.Cells(lRow, n + 3).Delete Shift:=xlToLeft
End If
Next lRow
End With
End Sub