JILBO
05-21-2021, 02:41 AM
Hi,
Hopefully can explain this well enough, I've attached a workbook with 2 Worksheets , CTR Data & CTR Out
I'm after some code that can create a new workbook from the CTR Out Template once its been populated in sequence with the values from the table in the CTR Data Sheet. The Name of the file is the 'Number' (which I also required within cell c5 on the CTR out.
The CTR Data table {CTR_Data} could be anything from 1 to 50 rows long.
Thanks In Advance
Hopefully can explain this well enough, I've attached a workbook with 2 Worksheets , CTR Data & CTR Out
I'm after some code that can create a new workbook from the CTR Out Template once its been populated in sequence with the values from the table in the CTR Data Sheet. The Name of the file is the 'Number' (which I also required within cell c5 on the CTR out.
The CTR Data table {CTR_Data} could be anything from 1 to 50 rows long.
Thanks In Advance