Hi there
I was wondering if the below is possible using VBA?
I have a spreadsheet containing many sheets with different products.
Each Product sheet is comprised as follows:
No header row
Data contained from columns A to T
The rows vary in number
I also have a sheet named Template in the same workbook as the products.
What I'm trying to do is use VBA to copy each of the product tabs and paste them one by one into the Template sheet(paste into cell a3) and then save as a separate workbook based on the contents of cell F3 in the template.
The Template worksheet is comprised as follows:
Blank from columns A to T
Header rows in rows 1 and 2
Formula contained in columns U to Z(starting from row 3)
I was wondering if the below is possible using VBA?
I have a spreadsheet containing many sheets with different products.
Each Product sheet is comprised as follows:
No header row
Data contained from columns A to T
The rows vary in number
I also have a sheet named Template in the same workbook as the products.
What I'm trying to do is use VBA to copy each of the product tabs and paste them one by one into the Template sheet(paste into cell a3) and then save as a separate workbook based on the contents of cell F3 in the template.
The Template worksheet is comprised as follows:
Blank from columns A to T
Header rows in rows 1 and 2
Formula contained in columns U to Z(starting from row 3)