How To Create and Name Worksheets Based on a List via an Excel Macro

Excel allows you quite a lot of freedom to customize your user experience via the use of macros. This tutorial will show you how to create and name worksheets using an existing list via a macro.

Create Worksheets Using a List via an Excel Macro

This code will help you to automatically create and rename worksheets, based on a list that exists in another sheet:

Sub CreateSheetsFromAList()

Dim MyCell As Range, MyRange As Range

Set MyRange = Sheets("Summary").Range("A10")

Set MyRange = Range(MyRange, MyRange.End(xlDown))

For Each MyCell In MyRange

Sheets.Add After:=Sheets(Sheets.Count) 'creates a new worksheet

Sheets(Sheets.Count).Name = MyCell.Value ' renames the new worksheet

Next MyCell

End Sub

Image: © Dzmitry Kliapitski - Shutterstockom

Spread the love

Leave a Comment