Posts by ShruthiDevadiga

    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