Value Of Cells to Names of Worksheets

[SimmonsDeux]

Guys,
I have names in a range of cells (B9:B72) in a workbook called Master Schedule. I need separate worksheets for each of these names. If possible, I'd like to create a function that creates new sheets and names them according to the range of cells in this workbook. If further explanation is needed, please let me know.

 

[Michael M]

Try this

Sub MM1()
Dim ws As Worksheet, i As Long
For i = 9 To 72
Worksheets.Add.Move after:=Worksheets(Worksheets.Count)
   ActiveSheet.Name = Worksheets("Master").Range("B" & i).Value
Next i
End Sub