create files with contact information list

secoo140

Board Regular
Joined
Oct 12, 2013
Messages
83
Office Version
2010
Platform
Windows
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
 
Last edited by a moderator:

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

Leith Ross

Well-known Member
Joined
Mar 17, 2008
Messages
1,874
Office Version
2010, 2007
Platform
Windows
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

Board Regular
Joined
Oct 12, 2013
Messages
83
Office Version
2010
Platform
Windows
sb123 is the password.
sorry about that
 

Watch MrExcel Video

Forum statistics

Threads
1,100,056
Messages
5,472,205
Members
406,809
Latest member
haf19

This Week's Hot Topics

Top