Use list to input employee ID to template, copy it, and repeat next down in list

[wherdzik]

Hello good people,

I am building a basic dashboard, I have created a master template which I would like to first make copy of the template, input an employee ID in a certain cell and repeat for the next employee.

Steps required:
1. Make copy of Employee 2 worksheet ---(this is the master template).
2. Grab first employee ID, located in A4 of the List worksheet.
3. Repeat until end of list is completed.


I have over 200 of these templates that I need to create so just looking for a way to eliminate calluses on my finger tips

I have attached a file for reference.
Thank you kindly.

[Logit]

.
So ...... what you will end up with, is the existing workbook with 200 individual sheets, each sheet is a template for the specific Employee Number.

You are not needing the sheet tab name to be changed for each employee number ?

Also, you have stated pasting the Employee ID Number in the appropriate location .... but not the name ?

[wherdzik]

If you can make so that it names it with the employee ID that would be great.
In my master document each individual tab will be named with the following naming convention.

EmployeeID_LastName
Eg. 11111_Smith

If I can go into the code later and augmented for this format that would be great.

thank you thank you!!!!!!

[Logit]

.
Give me some time. Lots of projects going on at this time.

[wherdzik]

Thank you so much I am at your mercy I don't need this probably for another week or two until I have to migrate everything together because I don't actually have all the data feeds... Thank you kindly

[Logit]

.
Paste in a REGULAR MODULE :

Please Login or Register  to view this content.

[wherdzik]

All I have to say is wow. I wish I could do what you can do.
Amazing. Thank you thank you!

[Logit]

.
You are welcome.