Need to create multiple tabs based on data in table
Solved/Closed
Kylana
-
27 Dec 2016 à 17:57
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Contributor Last seen 6 September 2024 - 29 Dec 2016 à 03:36
vcoolio Posts 1411 Registration date Thursday 24 July 2014 Status Contributor Last seen 6 September 2024 - 29 Dec 2016 à 03:36
Related:
- Data tabs
- Tmobile data check - Guide
- How to close tabs on android - Guide
- Icloud tabs not closing - Guide
- How to copy data from one excel sheet to another - Guide
- Data transmission cables - Guide
3 responses
vcoolio
Posts
1411
Registration date
Thursday 24 July 2014
Status
Contributor
Last seen
6 September 2024
262
27 Dec 2016 à 18:40
27 Dec 2016 à 18:40
Hello Kylana,
Could you show us an example of how your work book is set out please showing inputs and expected results and especially the set out of your template.
Upload a sample of your work book (be careful with any sensitive data) to a free file sharing site such as DropBox, ge.tt or SpeedyShare then post the link to your file back here.
We should then be able to work through it with you to a satisfactory conclusion.
Cheerio,
vcoolio.
Could you show us an example of how your work book is set out please showing inputs and expected results and especially the set out of your template.
Upload a sample of your work book (be careful with any sensitive data) to a free file sharing site such as DropBox, ge.tt or SpeedyShare then post the link to your file back here.
We should then be able to work through it with you to a satisfactory conclusion.
Cheerio,
vcoolio.
vcoolio
Posts
1411
Registration date
Thursday 24 July 2014
Status
Contributor
Last seen
6 September 2024
262
27 Dec 2016 à 20:34
27 Dec 2016 à 20:34
Hello Kylana,
I don't see any images in your last post.
Create a copy of your work book, use dummy data (just a few rows will be fine) and then upload it as per my post #1.
Cheerio,
vcoolio.
I don't see any images in your last post.
Create a copy of your work book, use dummy data (just a few rows will be fine) and then upload it as per my post #1.
Cheerio,
vcoolio.
KylanaG
Posts
3
Registration date
Tuesday 27 December 2016
Status
Member
Last seen
28 December 2016
28 Dec 2016 à 10:34
28 Dec 2016 à 10:34
Here are the links to the images, the spreadsheet is a beast already and a lot of the hidden tabs I can't share.
Part of the input page
https://www.dropbox.com/s/2m7q0sui3jjhxub/Input%20Page.PNG?dl=0
Part of the template which shows where things need to go
https://www.dropbox.com/s/6k1kocszpodiwlw/Template.PNG?dl=0
Part of the input page
https://www.dropbox.com/s/2m7q0sui3jjhxub/Input%20Page.PNG?dl=0
Part of the template which shows where things need to go
https://www.dropbox.com/s/6k1kocszpodiwlw/Template.PNG?dl=0
KylanaG
Posts
3
Registration date
Tuesday 27 December 2016
Status
Member
Last seen
28 December 2016
28 Dec 2016 à 18:35
28 Dec 2016 à 18:35
Just in case somebody wants what was used this is what I did
Sub CreateSheetsFromAList()
Dim MyCell As Range, MyRange As Range
Set MyRange = Sheets("Project Data Input").Range("G18")
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
Sub CreateSheetsFromAList()
Dim MyCell As Range, MyRange As Range
Set MyRange = Sheets("Project Data Input").Range("G18")
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
vcoolio
Posts
1411
Registration date
Thursday 24 July 2014
Status
Contributor
Last seen
6 September 2024
262
29 Dec 2016 à 03:36
29 Dec 2016 à 03:36
Hello Kylana,
Its good to see that you have been working on this yourself whilst waiting for a reply. Well done!
Thanks for sharing your resolution also.
Be careful with the loop type code in your last post as, although it works fine, there is no check in the code for duplicate names and Excel may throw up an error message warning you that it won't allow sheets to have the same name. However, if you delete the names in your list as you go, then there shouldn't be any issues.
Again, well done!
Cheerio,
vcoolio.
P.S.: The following thread may be of interest to you:-
https://ccm.net/forum/affich-910283-a-macro-to-create-new-copy-and-name-worksheets-based-on-a-list#top
Its good to see that you have been working on this yourself whilst waiting for a reply. Well done!
Thanks for sharing your resolution also.
Be careful with the loop type code in your last post as, although it works fine, there is no check in the code for duplicate names and Excel may throw up an error message warning you that it won't allow sheets to have the same name. However, if you delete the names in your list as you go, then there shouldn't be any issues.
Again, well done!
Cheerio,
vcoolio.
P.S.: The following thread may be of interest to you:-
https://ccm.net/forum/affich-910283-a-macro-to-create-new-copy-and-name-worksheets-based-on-a-list#top
27 Dec 2016 à 18:55
The "Project" on the input is actually the building. I'm looking to copy the Building Name, Unit Number, time in unit & bed/bath into this template. Some projects the table is only maybe 20-40 units but sometimes it's a couple hundred. I'm not sure having the form in excel would work best but my end goal is to be able to print out a page for each unit in each building for the inspections.