Hi,
The Example that Domski posted in:
http://www.excelforum.com/excel-prog...ml#post2628633
is almost what I need as well, but I can't quite work out how to modify it to achieve the results I need. (VBA is not a strong point of mine).
So in addition to creating individual workbooks with names derived from a master workbook, I need it to create additional worksheets per workbook (from the template), and write a couple bits of information in each generated work sheet. I have attached an example. So the result will be: The number of Workbooks depending on the number of "Save Worksbook Name"s, each with having 4 Worksheets (Template1, Template2, Template3, Template4), with each Template worksheet having the 2 beits of info written to it ("Name" & "Company").
The assistance will be much appreciated!!!
Cheers!
Brad
Bookmarks