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.



  • Possibly...

    Sub Files_from_Worksheets()
        ThisWorkbook.Worksheets(Array("T2", "T3")).Copy
        ThisWorkbook.Worksheets(Array("T4", "T5", "T6")).Copy
    End Sub

    If I've been helpful, let me know. If I haven't, let me know that too. 

  • .

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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!