Spilt into multiple workbooks with specified format excel file

Lalaiah

Hi All,

I am working on splitting multiple workbooks based on employee ID and with specified format excel file provided by us ( each employee-specific cell needs to be updated based on employee ID and create a new workbook for each employee).

Attaching example files ( Base file & Template file)

Regards,

Lalaiah

Employee Data base.docx

Qiu

@Lalaiah 
I can not do 100% as your request about the formatting. Hope you would accept this.

This is actually Macro in Macro...

20210304-OutputExcelFileswithTemplate.yxzp

OutputTemplate.xlsx