create files with contact information list

[secoo140]

Hello,
I have a list of contact information and a template to transfer it to.


Information that has become a row will go to a fixed place in the template.


how can we create a copy code for this?


creating a copy of the existing template file in accordance with the number in column B would be useful to avoid destroying the template.

contact information

https://drive.google.com/file/d/1LkKU9DsRpuF47lAyL2WclrSQeIZTiO2t/view

template

https://drive.google.com/file/d/183EbHuzqLSlrnPWrSXJfOBZALcCe00n5/view

 

[Leith Ross]

Hello secoo140,

A big obstacle to creating and testing code for your workbook is the worksheets are password protected. Can you post the password or passwords for the worksheets?

 

[secoo140]

sb123 is the password.
sorry about that

 

[secoo140]

it is fixed. There is no password.