c-lake

Sub DuplicateTemplateAndFillC1()
    Dim wb          As Workbook
    Dim wsList      As Worksheet
    Dim rngNames    As Range
    Dim cell        As Range
    Dim templateWs  As Worksheet
    Dim newWs       As Worksheet
    Dim createdCount As Long
    
    ' 1) Tweak these to match your setup: