• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Create copy of sheet based on name

C

coolkiran

Member
Hi Everyone

I have macro code written workbook, which contains sheet called "Teachers List". For each teachers have multiple students and have templates.

I need a macro which will generate new workbook for each teachers and need to copy template from main workbook and paste in new workbook for each student.

Column A is Teachers name, Column D is Student name and Column E is Template name.

Eg: For ram1986@gmail.com workbook will have 2 sheets as "A" and "C". and for these 2 sheets we need to copy paste Template 1 data.

I have attached my file.
 

Attachments


Hi !

As a starter : use Worksheets.Copy method to
create the new workbook with the first template …
​
 
You must log in or register to reply here.
Back
Top