VBA: Create sheets from list

Posts
1
Registration date
Friday July 20, 2018
Last seen
July 20, 2018
-
Hello,
suppose i have value in column A from 1 to 10 then i want to create a sheet from 1 to 10 using macro



See more 

Your reply

2 replies

Posts
10939
Registration date
Monday June 3, 2013
Status
Moderator
Last seen
December 14, 2018
0
Thank you
So record a macro of it and do it!

Highlight the row, cut it, select the tab, new tab, rename it "1", highlight the first row, paste the row!

It is that simple!

Have FUN!
Respond to ac3mark
Posts
2440
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 13, 2018
0
Thank you
Since the macro recorder doesn't show you how to loop, give this code a try:
Sub RunMe()
For Each cell In Range("A1:A10")
    Sheets.Add
    ActiveSheet.Name = cell.Value
Next cell
End Sub


Or, when you want the order of sheets reversed:
Sub RunMe()
For Each cell In Range("A1:A10")
    Sheets.Add after:=Sheets(Sheets.Count)
    ActiveSheet.Name = cell.Value
Next cell
End Sub


Best regards,
Trowa
Respond to TrowaD