Need macro/vba that creates new sheets for each flake from a template sheet

[Goakseeker]

Hi!

I need help creating some code that is above my head. Don’t have very much vba experience.

Ideally I’d have a code activated by a button that creates a sheet for each row of data selected (example selected D8:D17 10 new sheets in this example) each sheet from a template worksheet I have saved in templates called YTemplate. (So not just a new blank worksheet but the template.

It would be helpful if each new sheet had the data the in cell that it is created from input in each sheet. For example new sheet created for D8 would have the number D8 contained in a certain cell in the new sheet like cell B3 of the template sheet created.

Thanks for your help on this!

[AlphaFrog]

It may be easier to have the Template sheet in the same workbook. You could hide the template sheet.

What do you want to name the tabs of the new sheets?

For each selected cell, this code duplicates a hidden Template sheet, puts the cell value in B3, and names the sheet as the cell value.

Please Login or Register  to view this content.

[Goakseeker]

Hi AlphaFrog,

I tried the code and it works to create another sheet. It does not seem to be putting the contents of the selected cell in the new sheet B3.

I like your idea of keeping the Template as a hidden sheet that can work.

Id like to name each sheet the contents of the selected cells and the cell to the right of the selected cell -> like formula =D8&E8. with that i can make sure there are no sheets being made with the same name and causing problems.

Thanks So Much for your help!

Edit:
Actually I fixed the B3 problem by writing in ActiveSheet.Range.("B3")
That part works quite well now.

Is there any way to make this code run by a button I put on the original sheet?

[AlphaFrog]

Please Login or Register  to view this content.

Assign a macro to a Form or a Control button

[Goakseeker]

Thank you AlphaFrog!

This works awesomely and will be so helpful for my project.

I have another code question for you, but it is somewhat unrelated. Is it appropriate to ask it here or should I mark solved and make a new post?

[AlphaFrog]

You're welcome. Thanks for the feedback.

Mark this solved and post a new thread.