Dear Experts ,
i will try and explain what i need to get done ,
I have a workbook with many tabs say test1,test2,test3
What i want the macro to do is loop through the tabs and create separate workbooks based in the same folder
Say the workbook named "test.xls" is in a desktop and has tabs test1 ,test2 , test3 what i want the macro to do is create separate workbooks for each such tab and having same name as tab name i.e test1.xls , test2.xls etc containing the data contained in this tabs
This new workbooks can be contained in the same location as the original workbook ,
I attach a input parent file and outputted tabs which i would like ,
Thanks in advance ,
Humble regards ,
Amlan Dutta
Bookmarks