I need a VBA to create a set number of sheets based upon the number entered. But each sheet will have the same template entered into it.
Then, Title the sheets based upon the names written.
and finally have the top information auto entered into each report (sheet)
Im newer to VBA so if anyone can help, i'd be greatly grateful.
ill attach the workbook:
Copy of report form.xls
Hi, Kram222,
please try this code as a start. You need to have unique names for the students (or maybe their ID) otherwise a run time error while trying to rename the sheets might occur:
Ciao,
Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
Hello Kram222,
I am not sure as to which sheet you want to use as your "Template", but the attached WorkBook should give you a start.
If you need to use another Sheet as your "Template", just change the Code accordingly.
The Code already in the sample WorkBook:
Also see the "Please consider note at the bottom of this post.Please Login or Register to view this content.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Maybe try this:
abousettaPlease Login or Register to view this content.
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
Hello Kram222,
I have revised the sample WorkBook for you consideration.
Please try the attached Workbook.
Originally Posted by HaHoBe
Hi, Kram222,
please try this code as a start. You need to have unique names for the students (or maybe their ID) otherwise a run time error while trying to rename the sheets might occur:
Ciao,Please Login or Register to view this content.
Holger
This Works great! The coding works well enough for what i need it to do! thanks again! you really saved me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks