Copy and rename tab based on list

[crocco]

Hi all,

I have a tab called ‘template’

I have a tab called ‘products’ with a columnar list of text strings starting in cell A2.

I would like some VBA that copies and renames the ‘template’ tab for each item in the string list starting on cell A2 on the ‘products’ tab.

For example:

If products tab cell A2 = “Apples” and products tab cell A3 = “Pears”. The VBA I need would copy the ‘template’ tab twice and rename the tabs ‘Apples’ and ‘Pears’ respectively.

I will be left with three identical tabs called ‘template’, ‘apples’ and ‘pears’ (and the originals ‘products’ tab too).

I would like this to work for any number of items in the list on the ‘products’ tab.

Thanks!

 

[BlueAure]

I would hope that someone messing around with VBA would at least be exposed to the idea of loops, but I see your point Joe. I guess I just don't like the idea of people not wanting to learn. I mean, if you're using something, why not learn how it works! I don't buy people's excuses of "not needing to know". I'm more of the the opinion that if you use a thing, you should at least know enough to be dangerous with it.

 

[crocco]

Haven’t used this board in a while but you guys are all still amazing as ever!

 

[crocco]

Amazing thanks

 

[Joe4]

You are welcome.
Glad we were able to help.