Courtsey of Youtube.This Video content is delivered to you directly from

COMBINE Multiple Excel WORKBOOKS into One

Uploaded by: smilingcnab


Link to VBA Code We might need to combine multiple workbooks into one workbook in order to analyse or present the information better. Though this can be done manually, by moving or copying all the worksheets from different workbooks into one workbook, but it would be time consuming and prone to errors. Moreover if there are a large number of workbooksworksheets, then the problem is even bigger. However, we have a solution to this and it would not take more than a few seconds to get all workbooks merged into one. Here is the 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 video on how to use this code. Merge Two or More Excel Workbooks into One If you want to combine ONLY FIRST WORKSHEET of multiple Excel workbooks see this video

Please select the category that most closely reflects your concern about the video, so that we can review it and determine whether it violates our Community Guidelines or isn't appropriate for all viewers. Abusing this feature is also a violation of the Community Guidelines, so don't do it.

Oops, your web browser will be unsupported soon.

Our site is optimized with a wide range of browsers, please upgrade to a modern, fully supported browser. Find the latest versions of supported browsers below.

Get Latest


By Mozila

Internet Explorer

By Microsoft


By Google