Need to create multiple tabs based on data in table
Solved/Closed
Kylana
-
Updated by KylanaG on 27/12/16 at 06:51 PM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Dec 29, 2016 at 03:36 AM
vcoolio Posts 1404 Registration date Thursday July 24, 2014 Status Moderator Last seen September 15, 2023 - Dec 29, 2016 at 03:36 AM
Related:
- Need to create multiple tabs based on data in table
- Create skype account with gmail - Guide
- How to close tabs on android - Guide
- Create snapchat account - Guide
- Create instagram account on pc - Guide
- School time table software free download full version - Download - Organisation and teamwork
3 responses
vcoolio
Posts
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Dec 27, 2016 at 06:40 PM
Dec 27, 2016 at 06:40 PM
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
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Dec 27, 2016 at 08:34 PM
Dec 27, 2016 at 08:34 PM
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 December 27, 2016
Status
Member
Last seen
December 28, 2016
Dec 28, 2016 at 10:34 AM
Dec 28, 2016 at 10:34 AM
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 December 27, 2016
Status
Member
Last seen
December 28, 2016
Dec 28, 2016 at 06:35 PM
Dec 28, 2016 at 06:35 PM
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
1404
Registration date
Thursday July 24, 2014
Status
Moderator
Last seen
September 15, 2023
259
Dec 29, 2016 at 03:36 AM
Dec 29, 2016 at 03:36 AM
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
Dec 27, 2016 at 06:55 PM
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.