How to create worksheet with name list

[aparvez007]

Hi All,

Please help. I want to create worksheet with name list. I have 50 name and I want to create sheet with each name.


Regards,
pAvi

 

[Hui]

I assume this is using an Addin as I have never seen that screen in Excel?

 

[Hui]

If you want some code:

Sub Add_Sheets()

Dim c As Range
For Each c In Selection
  Sheets.Add After:=Sheets(Sheets.Count)
  Sheets(Sheets.Count).Name = c.Text
Next

End Sub

Copy the above into a Code Module in VBA

Select a range of names
Alt F8
Select Add_Sheets and Run

 

[Debraj]

I think you already have this ad-ins / customer service Number..

http://www.extendoffice.com/product/kutools-for-excel/create-sequence-worksheets.html

 

[aparvez007]

Thanks Hui sir it's working fine.
@Debraj : image I uploaded is for representation only.

Regards,
pAvi