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

December 2017

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 may 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: © Microsoft.
Published by jak58. Latest update on December 3, 2017 at 04:58 PM by owilson.
This document, titled "How To Create and Name Worksheets Based on a List via an Excel Macro," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (ccm.net).
Excel - Display an image in a worksheet
Excel/VBA - Color part of a column