Create worksheets with names from a list
Solved/Closed
Related:
- Creating worksheets from a list of names
- My contacts list names - Guide
- Ideogram ai names - Guide
- Wow monk names - Guide
- Counter strike 1.6 cheats list - Guide
- How to change your best friends list on snapchat to 3 - Guide
1 response
OK so you want to hook into another external list, and create a tab for it? That is really complicated, with path names and such. Let us start with dynamically creating the tab. what do you think about starting there?
Let us know where you get stuck, as we do not provide turn key solutions, but help when stuck. Post some code and we can guide you. I like to start with making a MACRO and reverse-engineering it to fit my needs. Like so:
You will notice where I select Sheet1, cell A4, that value is what was copied, which happened to be the name of the tab "tab 4".
I hope this makes sense, as now all you need to do is loop through an array, creating and renaming each tab!
Have FUN!
I have said it once, I will say it again. IT!
Let us know where you get stuck, as we do not provide turn key solutions, but help when stuck. Post some code and we can guide you. I like to start with making a MACRO and reverse-engineering it to fit my needs. Like so:
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 10/15/2015 by a BAD-A$$ MFR
'
'
Sheets("Sheet3").Select
Sheets.Add
Sheets("Sheet1").Select
Range("A4").Select
Selection.Copy
Sheets("Sheet4").Select
Sheets("Sheet4").Name = "tab four"
End Sub
You will notice where I select Sheet1, cell A4, that value is what was copied, which happened to be the name of the tab "tab 4".
I hope this makes sense, as now all you need to do is loop through an array, creating and renaming each tab!
Have FUN!
I have said it once, I will say it again. IT!
Oct 16, 2015 at 06:46 AM
I have replaced "sheet 3" above with the name of the worksheet that contains the list of names for the new worksheets ("SUMMARY ALL NOMINALS"). the cell with the first worksheet name is cell "U4" . The other required new worksheet names are in cells U5, U6 , U7 etc
Cab you see where I have gone wrong from the below at all ?
Sub LISA()
Sheets("SUMMARY ALL NOMINALS").Select
Sheets.Add
Sheets("SUMMARY ALL NOMINALS").Select
Range("u4").Select
Selection.Copy
Sheets("Sheet4").Select
Sheets("Sheet4").Name = "u4"
Oct 16, 2015 at 06:58 AM
Regards and happy weekend
Sub CreateSheetsFromAList()
Dim MyCell As Range, MyRange As Range
Set MyRange = Sheets("Summary all nominals").Range("U4")
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
Oct 16, 2015 at 04:56 PM