Copy sheet, add sheet name and headline from list.

[Foolzrailer]

Hello

I'm trying to make a lot of copies of the same sheet template, where the sheet name and headline needs to be pulled from a list. I've tried illustrating my wishes below.

Basically I have this template where in I've manually renamed the sheet name to 1 and the headline is Test 1:
http://i.imgur.com/HbmOSZY.png

I would like for this to somehow be automated as I have about 136 sheets I need to copy and rename, as well as add a headline.
http://i.imgur.com/YjNXH3p.png

What I'm thinking the steps are: Copy Sheet "1", rename that new sheet from List of Vejnavne to "2", add headline Test 2. Repeat, for 3, 4, 5. etc.

Now the names are not supposed to be test 1, 2.... These are censored, why I need for it too pull from the list.

Is this possible? Any help would be much appreciated!

 

[My Aswer Is This]

So you want to make copies of a sheet named("Template") and name the new copies from a list which is where?
And make how many copies? And get the Row(1) data from where?

 

[Foolzrailer]

Thank you for the reply.

Yes, I would like to make a copy of the sheet named "Template", naming them from a list which is in the same Workbook in a sheet called "Liste med vejnavne", column A3-A138 named "Unikt Id" (there are 136 different ids, so 136 copies in principle).
The Headline, row data (Test 1), is also from the same list "Liste med vejnavne" just in column B3-B138.

If it's easier, it doesn't need to be in one script? Perhaps just copy the sheet 136 times, then rename all sheets from list and then add the headline in the row? Not sure if this makes any difference, as I'm not entirely familiar with VBA script.

Again, thank you for the help!

 

[RoryA]

Welcome to the forum.

Please take a minute to read the forum rules, especially regarding cross-posting, and then add links to your posts in other forums. Thanks.

 

[My Aswer Is This]

I do not understand this part:

The Headline, row data (Test 1), is also from the same list "Liste med vejnavne" just in column B3-B138.


What is a "Headline"

What is (Test1)

 

[My Aswer Is This]

So we have another cross poster I guess. Second one for me tonight. I will move on.

Welcome to the forum.

Please take a minute to read the forum rules, especially regarding cross-posting, and then add links to your posts in other forums. Thanks.