How to create auto sheets and give same headings for all
Closed
Chaitucool4u
TrowaD
- Posts
- 2
- Registration date
- Thursday January 26, 2017
- Status
- Member
- Last seen
- February 7, 2017
TrowaD
- Posts
- 2884
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 21, 2022
Related:
- How to create auto sheets and give same headings for all
- Auto create info sheets from master spreadsheet ✓ - Forum - Excel
- Macro to create new sheet and copy data - Forum - Excel
- Excel macro to create new sheet based on value in cells - Guide
- How to create new sheets for each row in excel? ✓ - Forum - Excel
- Macro to Create New Workbook and Copy Data at Each Change of X - Forum - Excel
2 replies
TrowaD
Feb 7, 2017 at 11:46 AM
- Posts
- 2884
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 21, 2022
Feb 7, 2017 at 11:46 AM
Hi Chaitanya,
Create a template sheet with all the headers in place and then instead of adding a new sheet, copy the template sheet and rename it.
Replace:
With:
When you don't like to see the template sheet, then use this:
Best regards,
Trowa
Create a template sheet with all the headers in place and then instead of adding a new sheet, copy the template sheet and rename it.
Replace:
Sheets.Add.Move after:=Sheets(Sheets.Count) ActiveSheet.Name = sDay
With:
Sheets("Template").Copy after:=Sheets(Sheets.Count) ActiveSheet.Name = sDay
When you don't like to see the template sheet, then use this:
Sheets("Template").Visible = True Sheets("Template").Copy after:=Sheets(Sheets.Count) ActiveSheet.Name = sDay Sheets("Template").Visible = False
Best regards,
Trowa
TrowaD
Feb 13, 2017 at 11:40 AM
- Posts
- 2884
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 21, 2022
Feb 13, 2017 at 11:40 AM
Hi Chaitanya,
Make sure you named your template sheet "Template".
If your still having trouble you can upload (careful with sensitive data) your workbook to a free filesharing site like www.speedyshare.com or ge.tt and post back the download link.
Best regards,
Trowa
Make sure you named your template sheet "Template".
If your still having trouble you can upload (careful with sensitive data) your workbook to a free filesharing site like www.speedyshare.com or ge.tt and post back the download link.
Best regards,
Trowa
Feb 7, 2017 at 01:45 PM
I used that mentioned script but im getting error messgae.
Please share your email ID so that i can forward my excel sheet for better understanding.
Regards,
Chaitanya.Ch