Sub FiltrerIII()
Dim vCrit
vCrit = InputBox("Saisir votre critère de filtre,svp", "Filtrer", Application.UserName)
[A4:M600] = ""
With Sheets("DATA")
.Range("$D$3:$M$600").AutoFilter 3, vCrit
.AutoFilter.Range.Copy Destination:=Sheets("DASH BORD").Range("C3")
.ShowAllData
End With
Columns(15).AutoFit
On Error Resume Next
Application.ScreenUpdating = False
'recopie du logo
ActiveSheet.Shapes("LOGO").Delete
Sheets("LOGOS").Shapes(vCrit).Copy
[a1].Select
ActiveSheet.Paste
With Selection
.Name = "LOGO"
.ShapeRange.Left = [a1].Left
.ShapeRange.Right = [a1].Right
.ShapeRange.Top = [a1].Top
End With
[S1].Select
Application.CutCopyMode = False
End Sub