Combine Several Files Into One

  • I have several files saved under the same folder (which each has one worksheet only), I would like to single click of a button to combine all these files into one (by entering the location of the folder where all these files are saved), so that I can have just 1 file that contains different worksheets. thanks

    is it also possible to extract the name from a single cell from each file (same location on all files), and use that to rename the tab in the combined file?

  • Re: Combine Several Files Into One


    this macro opens every file in a directory and copies a certain sheet to the main workbook:

    Hope this gives you a start.


Participate now!

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