duplicate excel worksheets

Duplicate Excel Worksheet from names column

Ok, first ensure that you have a macro enabled workbook open.

  1. Click on the Developer tab
  2. Click on Visual Basic
  3. Click Insert and then Module
  4. Copy and Paste this code into the VB code window
Sub DuplicateNameSheet()
' DuplicateNameSheet Macro

   Dim i As Long, LastRow As Long, ws As Worksheet
   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

Share and Enjoy !


Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.