Seperate excel files based on tab names by vba

  • Hi All,

    I have excel file with multiple tabs with different tab names. I want to create new files with existing tabs from the excel file. For example say my present excel file has 6 tabs with tab name T1 to T6. I want to create new excel file with T2 and t3 and another with t4 t5 and t6. I will define this in T1. Is this possible by VBA coding.



  • .

    Without getting too fancy with coding .. here is one method :