Hi
I have 1 workbook with 2 sheets. Sheet 1 contains an invoice template and sheet 2 contains rows of customer details from columns A to O. These are your standard CustID, first name, last name, balance etc.
For each row in sheet 2, I want to copy over the values to specific locations in the sheet 1 template and then create a new workbook
After that, I want to move on to the next row, automatically creating new workbooks for each customer.
Please help with macro or VBA for this. Let me know if any questions.
I have 1 workbook with 2 sheets. Sheet 1 contains an invoice template and sheet 2 contains rows of customer details from columns A to O. These are your standard CustID, first name, last name, balance etc.
For each row in sheet 2, I want to copy over the values to specific locations in the sheet 1 template and then create a new workbook
After that, I want to move on to the next row, automatically creating new workbooks for each customer.
Please help with macro or VBA for this. Let me know if any questions.
