Excel VBA Macro: Add Sheets with Names From a List of Cell Values (Step-by-Step Tutorial)

Excel VBA Macro: Add Sheets with Names From a List of Cell Values (Step-by-Step Tutorial). In this video, we use a macro to add sheets to the end of a workbook with names that come from a list.

#ExcelVBA #ExcelMacro

[mahmooddadhiwala]

how does this video not have more views? nice and easy the best video with this kind of macro i have seen.

[sanchezdora]

Hi Greg, thank you for the video, awesome and very clear explaining. I have a question, for each new sheet that I create from the list (Column A), I need to "copy" the Sheet indicated in the column B. have you any video with this option?. Thank you!

[blovett]

Thanks for the video, question, how do create worksheets from a list but a worksheet that is a template e.g. an attendance register template but opens with a the number of users in a list and name them accordingly

[yusuf]

wonderful video.. help me a lot.. could you share how to fill the new generated sheets with the same formats or text as per sheet no.1 (data).. I mean the data list remain the same in all new sheets but only the name of the sheets that is different.. thank you

[fitzy]

Awesome video! I've been able to get a much longer list (60 items) to go most of the way through until I get a run-time error. I know Excel has a limit of 255 tabs, but I'm only getting to maybe 39 before it stops. Any tips?? Also what if I wanted to replicate the format of a separate tab? What does that look like embedded as part of this tab replicator code?

[joseocasio]

Can you share how we can assign the name one per one instead all at the same time? Or How i can select the last cell info to assign as a worksheet name? Thanks

[cottagekeeper]

Thanks for sharing. Question, I copied a macro to name all my sheets based on a specific cell in each sheet. That cell has a concatenate formula that pulls in a date and amount and a reference number. I have one sheet that I use for a template and each time I want to copy the template I get an error and it asks me to debug, I imagine this is because you can't have two tabs with the same name. Once I paste the data into the copied sheet the error goes away. But sometimes I'm not able to paste anything. You seem very brilliant would love to know what you think is the best work around? Here is the code: Private Sub Target As Range)
Set Target = Range("G10")
If Target = "" Then Exit = VBA.Left(Target, 31)
Exit Sub
End Sub

[umarriluwan]

there is showing an error "Subscript out of range" and yellow heighlighted on

" = Sheets("Data").Cells(i, 1).Text " this line

[seenajeson]

What if the country name is longer than the maximum character length allowed in the sheet name field, how can we cut short the name to fit in the sheet name field?

[bendahmanfares]

Awesome video:
how i can Add Sheets with Names From a List if doen't existe
i hope you ca help me

[SunnySharma-mshd]

what is the code if the list consist of Dates?? I am getting error because I have dates in the list and want to add a sheet using dates in list