Hello,
How can I automatically create and name worksheets in a workbook based on a list that exists in another sheet "Summary" in the workbook? The list begins at cell A10. Mind you, this list will vary from workbook to workbook. Do you have some code already compiled to perform this?
E-Coli
Configuration: Windows Vista Internet Explorer 7.0
Hello E-Coli,
Sub CreateSheetsFromAList()
Dim MyCell As Range, MyRange As Range
Set MyRange = Sheets("Summary").Range("A10")
Set MyRange = Range(MyRange, MyRange.End(xlDown))
For Each MyCell In MyRange
Sheets.Add After:=Sheets(Sheets.Count) 'creates a new worksheet
Sheets(Sheets.Count).Name = MyCell.Value ' renames the new worksheet
Next MyCell
End Sub
I. |
Compare list names excel Count a name from one column only if another column contains a certian letter Cover letter when you don't have a name Excel generate drop down list from macro Excel if name added to dropdown list master list gets updated Excel macro select cell at bottom of list Excel return list of names Excel vba count number of names in a list Excel visual basic list sheet names Find the name from the list when filter is on Forgot linksys router name and password How to filter the list by name using vba macro List of excel formulas List of special characters in a file name Microsoft office home and student 2007 product key generator Sql server 2005 auto backup Windows shell, list dir with just the file names Xbox 2 name