Help with Macro to Merge Multiple files with Multiple Tabs

  • Hi,

    I need help with a macro to combine Multiple excel files and have the data in the tab

    Each excel file has 3 tabs max with fixed names, but the content in the tabs can be anything.

    So i need the macro to:

    A) Merger all the excel files into 1 master file with 3 tabs

    B) have the name of the file in the first column of the sheet of each row, so if i filter by the first column i can see all the data from that file.

  • Look at this video on how to achieve with Power Query which is part of Excel.

    External Content
    Content embedded from external sources will not be displayed without your consent.
    Through the activation of external content, you agree that personal data may be transferred to third party platforms. We have provided more information on this in our privacy policy.

  • Hello Funfex,

    See if this at least heads you in the right direction:-

    You'll need to place your file path in the variable stgP.

    I hope that this helps.



Participate now!

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