Professor Excel

Comments 3

  1. DIEGO

    Thank for article!
    Method3 contains the first working macro I found in order to merge sheets!
    (the other 4-5 macro I used ever cut one row at begin or end of each sheet to merge)

  2. David

    The downloadable workbook saved me a lot of time, but I found an error. I noticed that the 5th tab of my workbook wasn’t being brought into the data table with the other tabs. This is due to a formula error in cell A12. You will notice that the ROW() references jump from A4 in cell A11 to A6 in cell A12. This causes the 5th tab of the workbook to be excluded.

  3. Carlos

    On method 4, I am getting the follow error:

    At line ‘Open each workbook
    Workbooks.Open tempFileDialog.SelectedItems(i)

    I am receiving the follow error:
    Run-time error 1004
    Method Open of object Workbooks fail

    Any feedback please

Leave a comment

%d bloggers like this: