Sub CreerTableaux()
Dim Unique As New Collection 'contiendra la liste des villes sans doublon
Dim tablo() As Variant 'contient tout le tableau de la feuille 1
With Sheets("Feuil1")
fin = .UsedRange.Rows.Count
tablo = .Range("A2:G" & fin).Value
entete = .Range("A1:G1").Value
On Error Resume Next
For i = LBound(tablo, 1) To UBound(tablo, 1)
Unique.Add tablo(i, 3), tablo(i, 3)
Next i
End With
For Each ville In Unique
Sheets.Add
With ActiveSheet
ActiveWindow.DisplayGridlines = False
.Name = ville
.Range("A1:G1") = entete
k = 2
For i = LBound(tablo, 1) To UBound(tablo, 1)
If tablo(i, 3) = ville Then
For j = LBound(tablo, 2) To UBound(tablo, 2)
.Cells(k, j) = tablo(i, j)
Next j
k = k + 1
End If
Next i
.ListObjects.Add(xlSrcRange, Range("$A$1:$G$" & k - 1), , xlYes).Name = "Tab" & ville
.ListObjects("Tab" & ville).TableStyle = "TableStyleMedium9"
End With
Next ville
End Sub