Sub CreerFichiers()
Dim chemin$, F As Worksheet, tablo, i&, wb As Workbook
chemin = ThisWorkbook.Path & "\Mes fichiers\" 'à adapter
If Dir(chemin, vbDirectory) = "" Then MkDir chemin 'crée le sous-dossier
Set F = Sheets("Inventaire") 'à adapter
tablo = Sheets("Adresse").[A1].CurrentRegion.Resize(, 2)
Application.ScreenUpdating = False
Application.DisplayAlerts = False 'si un fichier est déjà créé
For i = 2 To UBound(tablo)
Set wb = Workbooks.Add(xlWBATWorksheet) 'nouveau document
With F.Cells(1).CurrentRegion
.AutoFilter 1, tablo(i, 1) 'filtre automatique
.Copy wb.Sheets(1).Cells(1)
.AutoFilter
End With
wb.Sheets(1).Columns.AutoFit 'ajustement largeurs
wb.SaveAs chemin & tablo(i, 2) & ".xlsx", 51
wb.Close
Next
End Sub