creating multiple file in excel with single template

[violetserrao]

I am working in a compnay as HR Executive and I have to create 1600 individual PMS forms. I have a template in excel and need to create for indiviual employee the forms.

Please can someone help me.

I am attaching the template and the spreadsheet with details.

Thanks in advance

Regards
Violet

[JBeaucaire]

Here's a macro from my website for filling out multiple copies of a template from a data sheet.

Please Login or Register  to view this content.

This was edited from the macro found here:

Data into Template

It operates from the data and template sheets being in the same workbook. You will need to expand the section that is inserting the values, and I didn't fill out the second template at all...had to leave something for you to do...

[violetserrao]

Here's a macro from my website for filling out multiple copies of a template from a data sheet.

Please Login or Register  to view this content.

This was edited from the macro found here:

Data into Template

It operates from the data and template sheets being in the same workbook. You will need to expand the section that is inserting the values, and I didn't fill out the second template at all...had to leave something for you to do...

Thank you for your reply.

As I click on create forms, I get an error.

Compile error

Next without for

I want to know, when i create the forms, will the data from the data sheet, will get updated in the self evaluation sheet for the following
Employee Name: Employee No. : Department & Location :


Designation : Last Review Date 01st Jan, 10 Type of Appraisal (Circle One)
Annual Other

Evaluator Years/Mos. In Present Position Mos. Supervised by Evaluator


Thanks

Violet

[JBeaucaire]

Corrected above. Download the file and/or code again.

NOTE: Do not QUOTE my entire post in yours. Just use the QUICK REPLY button.

[violetserrao]

Thank you once again.

When I click to to create forms.

I get the error Run-Time error 1004


Is it possible for me to get both the worksheets 1) Self Evalaution and 2) Manager Evaluation in single file for each employee when the form is created. As I need to give each employee both the sheets. Also Is there any way when the form is created, it is named with the Department + employee ID.

I know its asking for too much. Please I need your help.

Thanks

Violet

[royUK]

Please read the Forum Rules & take more care with your Thread Titles - edited this time

[JBeaucaire]

1) You don't need the popup, you want BOTH sheets for each employee
2) You don't need the "Create Separate Workbooks" prompt either, you DO want the macro to put each set of template sheets into a separate workbook and name the workbook: Department + employee ID

Try this:

Please Login or Register  to view this content.

I'm not getting those errors on when I run the existing macro, so if you continue to get specific errors on a new sheet you're trying, be sure to post that Up so I can see the error, too.

[JBeaucaire]

1) You don't need the popup, you want BOTH sheets for each employee
2) You don't need the "Create Separate Workbooks" prompt either, you DO want the macro to put each set of template sheets into a separate workbook and name the workbook: Department + employee ID

Try this:

Please Login or Register  to view this content.

I'm not getting those errors on when I run the existing macro, so if you continue to get specific errors on a new sheet you're trying, be sure to post that Up so I can see the error, too.

[violetserrao]

Thanks Jerry,

The Worksheet works fine. The issue is that when I click on NO to printing option. It still prints.

Thanks Once again

Violet

[JBeaucaire]

Code corrected above.

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

[violetserrao]

Thanks Jerry,

Its works!!!!.


Violet