Hello brothers,
I have a database file which has over 1000 rows and 5 columns.
* I need a VBA code for creating a new workbook from the information of each row.
* For each row, i need a different workbook with same template.
* New workbooks will take their names form the database files C and A columns.
* 5 values (A, B,C,D,E column values of each row) will be a added to new workbooks.
Sample DATABASE and EXAMPLE TEMPLATE pic are as followings:
I hope you can help me
I have a database file which has over 1000 rows and 5 columns.
* I need a VBA code for creating a new workbook from the information of each row.
* For each row, i need a different workbook with same template.
* New workbooks will take their names form the database files C and A columns.
* 5 values (A, B,C,D,E column values of each row) will be a added to new workbooks.
Sample DATABASE and EXAMPLE TEMPLATE pic are as followings:
I hope you can help me