Need help in combining each work sheet of multiple excel files separatly.

  • Hi,

    I need a macro to combine each work sheet of multiple excel file separately.
    For Example:
    I have multiple excel file,each having 9 worksheet ( Worksheet name is consistent in all the excel file- i.e. Allocation, Confirmation, LOE, Project code creation etc.)
    I need to consolidate the excel file in worksheet wise and create a single workbook with 9 worksheets consolidated. each excel files "Allocation" worksheet need to be consolidated and so on.
    I have very basic knowledge of VBA. Please help me in creating this macro.

    Thanks in Advance

Participate now!

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