Ok, first ensure that you have a macro enabled workbook open.
- Click on the Developer tab
- Click on Visual Basic
- Click Insert and then Module
- Copy and Paste this code into the VB code window
Sub DuplicateNameSheet() ' ' DuplicateNameSheet Macro ' ' Dim i As Long, LastRow As Long, ws As Worksheet Sheets("names").Activate LastRow = Cells(Rows.Count, 1).End(xlUp).Row For i = 1 To LastRow Sheets("template").Copy After:=Sheets(i) ActiveSheet.Name = Sheets("names").Cells(i, 1) Next i End Sub
*Note with the above your template sheet needs to be named template and your the sheet with your names on it has to be named names