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
   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

Share and Enjoy !

Shares

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.