A question from Askville:
How can I insert worksheets in excel and name them automatically from a list?
In an excel workbook, I have a list of 36 words and I want a separate worksheet for each of them – all named.
Write a macro. Something along the lines of:
Sub CreateAndNameWorksheets() Sheets("Words").Select Words = Cells.Range("A1:A36") For Each Item In Words Sheets.Add After:=Sheets(Sheets.Count) Sheets(Sheets.Count).Name = Item Next Item End Sub
The code above assumes that your list of words is stored in cells A1:A36 of the worksheet named Words.