Copy data from Multiple workbooks simultaneously into One excluding first row

  • okunamatata

    Changed the title of the thread from “Copy data from Multiple workbooks into One excluding first row” to “Copy data from Multiple workbooks simultaneously into One excluding first row”.
  • Save your "Master" workbook in the same folder where the workbooks you copy from are located.

    Open the "Master" workbook and try this code.

  • If your "Master" Workbook is saved in a different folder and you want to specify the folder where the files you want to copy from, this should work.

  • On both, I can't tell you why because I don't know what is in your folders.

    Does it get the data from all workbooks twice or just from one workbook.

    As mentioned, the workbook can not be saved in the same folder. If it is, you have to change this

    Code
    1. Workbooks.Open myPath & "\" & wb

    to this

    Code
    1. If wb <> ThisWorkbook.Name Then Workbooks.Open myPath & "\" & wb