Copy tab with custom name without duplication

[Abhijit2011]

Hello.. Hope all are doing well.
I'm trying create multiple copy of a Template tab/sheet based on the table on Index tab. On Index tab i have a table Emp_ID (col A), Emp_name (col B) and Tab_name (Col C). The macro will create a copy of Template tab, set the tab name as Index col C tab name and take Emp_Id and Emp name and put it on E2 and E3 of new tab. The below macro is working fine.

Please Login or Register  to view this content.

Now i want to put a process to avoid creating duplicated tab. Means if i add more entry to Index table and run the macro then it will copy Template and create tab for the new entries only. For existing entries where a tab is already exist, it should not create duplicate tab. how do i do it?

[AliGW]

Please check your Excel version is up-to-date in your profile. Thanks.

[PCI]

See next code

Please Login or Register  to view this content.

[Abhijit2011]

Thanks for the code.
When I'm executing the code with existing Tab, it's creating another tab as "Tab_Name". It's only getting created one time though. Is it expected?

[PCI]

Hops.
Try next code

Please Login or Register  to view this content.

[Abhijit2011]

Excellent!! It's working fine now. Thanks a lot.

[PCI]

Good, you're welcome.

[PCI]

I forgot to mention that the list of Tabs in sheet "Index" in column "C" is now dynamic.