Hello,
I am hoping someone could assist.
I wish to automate a large task that i have been assigned. I have a workbook with a list of employee names with their employee ids and dates of birth.
For each employee I need to open an already created workbook template (we can call it Template) which is saved in a location on my computer, the template has 3 tabs and I need to paste the employee id into sheet1 A1 of the template, name into sheet1 B1 of the template and date of birth into sheet1 C1 of the template. I then need to save as the workbook with the file name as employee id and name In another location on my computer.
I then repeat this with the next employee in my list in my workbook until the end of the list.
In my workbook, column A has the employee ids, column B has the name and column C has dates of birth. The list varies in length from month to month.
Is there a code that could do this?
Thanks in advance.
I am hoping someone could assist.
I wish to automate a large task that i have been assigned. I have a workbook with a list of employee names with their employee ids and dates of birth.
For each employee I need to open an already created workbook template (we can call it Template) which is saved in a location on my computer, the template has 3 tabs and I need to paste the employee id into sheet1 A1 of the template, name into sheet1 B1 of the template and date of birth into sheet1 C1 of the template. I then need to save as the workbook with the file name as employee id and name In another location on my computer.
I then repeat this with the next employee in my list in my workbook until the end of the list.
In my workbook, column A has the employee ids, column B has the name and column C has dates of birth. The list varies in length from month to month.
Is there a code that could do this?
Thanks in advance.