Merci 3GB
Je vais essayer. Je mets le code pour info de mon classeur
Sub Def_Tableau()
Dim Plage As Range
Sheets("Feuil1").Select
Set Plage = Range(Cells(2, 1), Cells(Cells(Rows.Count, 1).End(xlUp).Row, 1))
Plage.Select
On Error Resume Next
ActiveSheet.ListObjects("Tab_1").Unlist
ActiveSheet.ListObjects.Add(xlSrcRange, Range(Cells(1, 1), Cells(Cells(Rows.Count, 1).End(xlUp).Row, 1)), , xlYes).Name _
= "Tab_1"
ActiveSheet.ListObjects("Tab_1").TableStyle = "TableStyleLight8"
ActiveSheet.ListObjects("Tab_2").Unlist
Sheets("Feuil2").Select
ActiveSheet.ListObjects.Add(xlSrcRange, Range(Cells(1, 1), Cells(Cells(Rows.Count, 1).End(xlUp).Row, 1)), , xlYes).Name _
= "Tab_2"
ActiveSheet.ListObjects("Tab_2").TableStyle = "TableStyleLight8"
sNA = ""
lig = Sheets("Feuil1").Range("A65536").End(xlUp).Row
For i = 2 To lig
Sheets("Feuil1").Cells(i, 2).Select
sNA = Application.Index(Range("Tab_1[Reference]"), Application.Match(Sheets("Feuil1").Cells(i, 1).Value, Range("Tab_2[Reference2]"), 0))
If IsError(sNA) Then
ActiveCell.Value = "Vendu"
Else
ActiveCell.Value = sNA
End If
Next
End Sub
Encore merci pour l'aide que vous m'apportez