If Target.Address = "$F$2" Then
Dim LastRow&, LastRowList&
Dim wsData As Worksheet, wsState As Worksheet
Set wsData = Sheets("Feuil1")
Set wsState = Sheets([F2].Value)
wsState.Cells.Clear
wsState.Range("A1:B1").Value = wsData.Range("A1:B1").Value
LastRow = wsData.Range("A" & Rows.Count).End(xlUp).Row
wsData.Range("A1:C" & LastRow).AdvancedFilter Action:=xlFilterCopy, CriteriaRange:= _
wsData.Range("F1:F2"), CopyToRange:=wsState.Range("A1:B1"), Unique:=True
wsState.Select
Set wsData = Nothing
Set wsState = Nothing
End If
wsState.Range("A1:B1").Value = wsData.Range("A1:B1").Value
wsState.Range("A1:B1").Copy wsData.Range("A1:B1")
Ligne concernée :Nom de champ introuvable ou incorrect dans la plage d'extraction.
wsData.Range("A1:C" & LastRow).AdvancedFilter Action:=xlFilterCopy, CriteriaRange:= _
wsData.Range("F1:F2"), CopyToRange:=wsState.Range("A1:B1"), Unique:=True
Nom de champ introuvable ou incorrect dans la plage d'extraction.
wsData.Range("A1:B1").Copy wsState.Range("A1:B1")
wsState.Range("A1:B1").Copy wsData.Range("A1:B1")