Generate new tabs with contents similar to template tab

Resolved · Urgent Priority · Version 365

Wed 8 Mar 2023, 13:26 Delegate Lauren said...

Lauren has attended:
Excel VBA Introduction course

Generate new tabs with contents similar to template tab

Please could you advise on a macro to generate multiple tabs with the same contents as an existing tab witch contains a report template.
The names of the new tabs should be the same as those listed in column B on the first tab of the file.
Column A on the first tab of the file has a list of full names which should go in cell A2 of the new generated tabs.
I suppose we need to use a loop command that would go through columns A and B of the first tab to get the names of the new tabs and the content of cell A2 on the new tab.

Wed 8 Mar 2023, 17:49 Trainer Jens said...

RE: generate new tabs with contents similar to template tab

Hi Lauren,

Thank you for the forum question.

The forum is for questions, it is outside the scope to develop code for clients. Normally in a situation like this I would ask the client to send me the code and then answer the client's questions about the specific code.

I have done the code you can use (please find attached file), but I am using VBA code above our Excel VBA introduction level, but I hope it makes sense.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector