Professor Excel

Comments 2

  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.

Leave a comment

%d bloggers like this: