Please help!
I have a macro that creates multiple worksheets from a list. It uses a single template worksheet, "TEMPLATE", but auto-fills information from the list / table on my "MASTER" tab...
Private Sub CommandButton2_Click()
Dim sh1 As Worksheet, sh2 As Worksheet, c As Range
Set sh1 = Sheets("TEMPLATE")
Set sh2 = Sheets("MASTER")
For Each c In sh2.Range("A8", sh2.Cells(Rows.Count, 1).End(xlUp))
sh1.Copy After:=Sheets(Sheets.Count)
ActiveSheet.Name = c.Value: ActiveSheet.Range("A8") = c.Value
Next
End Sub
It's great... except it only allows me to reference one template worksheet. Ideally, I would like to have multiple template worksheets ("TEMPLATE 1", TEMPLATE 2", etc.) that I can assign individually to items on the list (probably with a drop-down list). That way, I can select which template file the macro copies for each individual item on the list. I'm hoping to accomplish this with one button after the fields have been filled out in the "MASTER" tab.
Thoughts? Suggestions? Prayers?
Thanks!
Bookmarks