Creating Sheets from a Template

My process begins with the "Monthly" worksheet. I receive the worksheet and need to populate my template workbook with the data in the following manner:
Assumptions:
1. The template workbook contains the Summary worksheet and 1 detail worksheet only populated with Headers.

Here's what needs to happen:
1. The information contained in the "Monthly" worksheet needs to populate my template workbook in the following manner:
- The detail template sheets need to copy themselves and populate with select data located in each row
of the "Monthly" sheet i.e. 1 row of data per worksheet
2. The worksheets need named according to the data listed in (Column B) of the "Monthly" worksheet.

DETAILS:
The data in the "Monthly" worksheet(Columns B:F) needs populated in my template workbook into (Columns A:E, Row3) creating seperate detail worksheets for each row listed on the "Monthly" worksheet.
After creating the worksheets they need named either from the data located in the detail sheet (Column A, Row 3) OR by taking the data in the "Monthly" (Column B) and naming the worksheets from there.

THE CATCH
The "Monthly" worksheet data is seperated into template workbooks based on the value in (Column E). Normally I need to sort by (Column E) first, then create template workbooks, then populate those workbooks. (which I can still do) Someone told me I should try and write a macro to create the template workbooks first then populate them, however, it all seemed overwhelming so I gave up on that part. I figued if I could get it to autopopulate I could delete text in my "monthly" worksheet and run the macro on the needed data only however many times I had to do it.

Your Template file sheet wk1 has many entries from rows 4 to 11. From where does that data come in?

Also, once the template has been copied and the sheet created, do you want to clear out the entries from the monthly tab?

The Monthly sheet has 4 rows of data.

The Template workbook doesn't have a sheet called "template", it has on called wk1, so that's the template?

What would the 4 new worksheets be called once they were created? Is wk1 still there as the template? (very confused)

Lastly, does this macro run FROM the template workbook, FROM the Monthly workbook, or FROM somewhere else (thus it would need to refer to both workbooks by some standard location?)

This macro will do what you want. You need only edit the PATH to locate the template workbook on your computer.

The macro can be run from anywhere, perhaps store it in your Personal.xlsb so it's available at all times.

The macro confirms that the current sheet onscreen is the "due" data you want to process, so that needs to be true. Then it will open a copy of the template, create sheets and stop.

Please Login or Register  to view this content.

If that takes care of your need, please select Thread Tools from menu above and set this topic to SOLVED.