Bonjour SophieB le forum
bah j'ai jeté ta macro, mais voilà la nouvelle
a+
Papou
'Macro Faite par Pascal RICHARD Paritec le 02/08/2018
Option Explicit
Sub Creation_Onglets_Selon_Modele()
Dim i&, a&, aa
With Feuil3
For i = 2 To .Range("A" & Rows.Count).End(3).Row
aa = .Range(.Cells(i, 4), .Cells(i, 8))
Sheets.Add after:=Sheets(Sheets.Count)
ActiveSheet.Name = .Cells(i, 4)
With ActiveSheet
ActiveSheet.Range("A1").Resize(UBound(aa), UBound(aa, 2)) = aa
End With
Next i
End With
End Sub