Bonjour,
A tester (et adapter à ta convenance).
Sub DécoupageSections()
Dim wsI As Worksheet, wsE As Worksheet, ss, n&, i%, chD$, nF$
chD = ThisWorkbook.Path & "\FichiersDécoupés"
On Error Resume Next
ChDir chD
If Err.Number <> 0 Then MkDir chD
On Error GoTo 0
chD = chD & "\"
Set wsI = ActiveSheet
Application.ScreenUpdating = False
Set wsE = Worksheets.Add(after:=wsI)
With wsI
n = .Range("F" & .Rows.Count).End(xlUp).Row
.Range("F1:F" & n).AdvancedFilter xlFilterCopy, , .Range("AZ1"), True
ss = .Range("AZ1").CurrentRegion.Value
.Range("AZ1").CurrentRegion.Offset(1).Clear
For i = 2 To UBound(ss)
nF = Replace(ss(i, 1), "/", " ") & ".xlsx"
.Range("AZ2") = ss(i, 1)
.Range("A1:AI" & n).AdvancedFilter xlFilterCopy, .Range("AZ1:AZ2"), wsE.Range("A1:AI1")
wsE.Copy
ActiveWorkbook.SaveAs chD & nF
Workbooks(nF).Worksheets(1).Columns("A:AI").AutoFit
Workbooks(nF).Close True
wsE.Range("A1").CurrentRegion.Clear
Next i
.Range("AZ1:AZ2").Clear
End With
Application.DisplayAlerts = False
wsE.Delete
End Sub
NB- Les fichiers créés sont enregistrés dans un sous-dossier du dossier contenant le classeur principal, intitulé : FichiersDécoupés.
Cordialement.