C
Chris
to all you experts out there, I need some help with creating a macro.
I have 2 workbooks.
workbook 1 has one sheet with a template
workbook 2 has one sheet with about 200 rows
I would like to do 2 things here.
-automatically create new worksheets and have them named based on the
data in column C from workbook 2 while at the same time use the
template from workbook 1 to be included in the new named sheets.
I also have data in Columns D, E , and F in workbook 2 that I also
need created along with the new named sheets, and created in column A
rows 1, 2, and 3 respective to the newly named worksheets.
Any idea on how to go about doing this or am I not explaining this
clear enough?
Any help is greatly appreciated.
Thanks,
Chris
I have 2 workbooks.
workbook 1 has one sheet with a template
workbook 2 has one sheet with about 200 rows
I would like to do 2 things here.
-automatically create new worksheets and have them named based on the
data in column C from workbook 2 while at the same time use the
template from workbook 1 to be included in the new named sheets.
I also have data in Columns D, E , and F in workbook 2 that I also
need created along with the new named sheets, and created in column A
rows 1, 2, and 3 respective to the newly named worksheets.
Any idea on how to go about doing this or am I not explaining this
clear enough?
Any help is greatly appreciated.
Thanks,
Chris