count & insert template sheets

I need a coding for count of "Reconciled" items and insert that number of template sheets.
Attached is the sheet for your better understanding.

With the help of attached example I need a coding which will count the number of items the word "reconciled" appears in control sheet (L:L) and should insert that number of template sheets. In this example the count is 16 so it should insert 16 new template sheets.
Pls note the count would not always be the same and count would not always be in cell L123.

After inserting the template it should be renamed as the combined value from the cells.
for example from control sheet the template should be renamed as from E8,D8 & F8
First should be affiliate then subdivision and then currency. It should include "-" between the names.
Kindly help.

--
Thanks,

Mayank Jain.
JLR Inter-Company Receivables.

The number "16" isn't really needed, is it? You just need one template added for each row that says "Reconciled" in column L, and named for E8-D8-F8 from the same row? Correct?

Please Login or Register  to view this content.

That macro goes into a regular module (Module1, Module2, etc.)

I think you uploaded the wrong file.

It appears my macro is a replacement for your Template_1 macro, correct?

So you want my code added into your Macro3 code? That macro doesn't seem to really do anything.

Perhaps you just need to create a third macro that runs the two macros.

Please Login or Register  to view this content.

You can put my macro in a module of its own if the options included above mine interfere with yours.

There's contact info on my website, link is in my signature.

But you would probably be best served by continuing to use the open forum. It's quite a team here of contributors.

==========
If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].


(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated. It is found across from the "time" in each of our posts.)