mountainman88
Board Regular
- Joined
- Jun 22, 2019
- Messages
- 109
- Office Version
- 2016
- Platform
- Windows
I have a tab called ‘list’ and and a tab called ‘template’.
on the ‘list’ tab there can be any number of unique items in Column A with a paired item in Column B.
I need some VBA that will copy the ‘template’ tab and rename it to each item in Column A from ‘list’ and then in cell C3 of the ‘template’ tab enter the corresponding text that is in Column B of the ‘list’ tab. This should loop until there are as many new renamed template tabs as there are items on the ‘list’ tab.
Eg. If ‘list’ A1 / B1 was Duck / Quack
the ‘template’ tab would be copied and renamed ‘Duck’ and ‘Quack’ would be input into cell C3 on the ‘Duck’ tab.
This would need to loop and be repeated for every row that has another pair of items on the ‘list’ tab.
thanks!
on the ‘list’ tab there can be any number of unique items in Column A with a paired item in Column B.
I need some VBA that will copy the ‘template’ tab and rename it to each item in Column A from ‘list’ and then in cell C3 of the ‘template’ tab enter the corresponding text that is in Column B of the ‘list’ tab. This should loop until there are as many new renamed template tabs as there are items on the ‘list’ tab.
Eg. If ‘list’ A1 / B1 was Duck / Quack
the ‘template’ tab would be copied and renamed ‘Duck’ and ‘Quack’ would be input into cell C3 on the ‘Duck’ tab.
This would need to loop and be repeated for every row that has another pair of items on the ‘list’ tab.
thanks!