Beschreibung
Link to VBA Code: http://www.exceljunction.com/how-to-merge-first-worksheet-of-multiple-excel-workbooks/
In this video we’ll see how to MERGE FIRST WORKSHEET from several Excel workbooks for example merging SUMMARY sheet from each of the workbooks to create the monthly SALES report.
[We have already seen in a previous video (https://youtu.be/JiAYngRcN0s) how to combine ALL worksheets from several workbooks, in this video we’ll see how to get only 1 sheet from each workbook]
Though this can be done manually, by moving or copying the worksheets from different workbooks into the master, but it would be time consuming and prone to errors, especially if there area large number of files to be handled.
However, we have a solution to this and it would not take more than a few seconds to get all the workbooks merged into one. We have a VBA code that can help us achieve this. Even those who are not well versed with VBA can easily get this done by simply following the steps on how to use this code.