Comments on: How to merge multiple Excel files into one

Merging multiple Excel workbooks into one file could be a cumbersome and long process. So, which is the best way to handle the problem: copy the sheet tabs, run VBA code or use a special tool? Continue reading →

Comments page 2

  1. The VBA Macro does not merge the data into one sheet. It only brings over sheets from other workbooks.

    1. Hi Dave,

      Exactly :) This whole article is about merging multiple Excel files into one, i.e. copying sheets from multiple workbooks into one workbook.

      If you are looking to merge data from multiple sheets into one sheet, you can try this VBA code or our Copy Sheets tool.

      1. Hi Svetlana,
        My requirement is quite similar to Dave's. So i went to the link provided by you above, But even that VBA code does not consolidate the data into one sheet, but only creates different sheets in the master sheet. Can you please help me?

Post a comment



Thanks for your comment! Please note that all comments are pre-moderated, and off-topic ones may be deleted.
For faster help, please keep your question clear and concise. While we can't guarantee a reply to every question, we'll do our best to respond :)