Hi Everyone,
I'm struggling to come up with a vba macro that does the following. Any help is appreciated.
I want the macro to auto generate new worksheets and copy a template onto that worksheet.
The "main" worksheet will have Column 1 and consists of part numbers, column 2 will consist of type (it will be scroll down with limited selections).
I will generate template worksheets in the same workbook. (template1,template2,template3....)
On the click of a button, it will auto generate worksheets based off column 1 (a worksheet per part number and rename that worksheet to that part number) and will either copy template1, template2,template3... depending on what is selected in column 2.
Thank you for the help. I hope it is not too complex or hard.
My OS is XP with office 2007.
I'm struggling to come up with a vba macro that does the following. Any help is appreciated.
I want the macro to auto generate new worksheets and copy a template onto that worksheet.
The "main" worksheet will have Column 1 and consists of part numbers, column 2 will consist of type (it will be scroll down with limited selections).
I will generate template worksheets in the same workbook. (template1,template2,template3....)
On the click of a button, it will auto generate worksheets based off column 1 (a worksheet per part number and rename that worksheet to that part number) and will either copy template1, template2,template3... depending on what is selected in column 2.
Thank you for the help. I hope it is not too complex or hard.
My OS is XP with office 2007.
Last edited:
