Create new worksheets from a list and then copy info into these from another worksheet

Hi there - I am a newbie to VBA but I have tried adapting code and have made some progress.

My main challenge is combining all the separate code snippets together.

Objective of code:

1. Create a unique list of values from a column in a particular sheet and paste this list in a new worksheet - I have the code for this

2. Reference this list and create new worksheets / Tabs based on this list i.e. if there are 3 elements in the list then 3 tabs are created with the corresponding name - I have the code for this

3. In these newly created tabs I need to paste a generic template with formulas from an existing worksheet in the same workbook i.e. all 3 of the newly created tables will have the identical template including the "Set print area" settings associated with the template sheet- I have this code to copy the contents but I'm struggling also copy the "Set print area settings and convert the landscape for printing"

4. In these newly created tabs, in Cell A1 I need to paste the name derived from the list which is also the name of the specific tab - I DON'T have this code.

My challenge is that I'm struggling to string these all together and execute parts 1, 3 & 4 in the same macro as part 2 i.e. as I loop through the list I want to paste the template (part 3) and then paste the template name in Cell A (part 4)

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Would really appreciate any guidance.

Thank-you.

Concatch

Hi Concatch,

Try the below code ...

Please Login or Register  to view this content.

No need for two loops...

Please Login or Register  to view this content.