COMBINE Multiple Excel WORKBOOKS into One | ExcelJunction.com

Link to VBA Code
www.exceljunction.com/combine...
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 workbooks/worksheets, 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 • COMBINE Multiple Excel...

[@senthil4707]

Hi,
Wow. That just worked. Thanks for sharing this info. I am able to combine 50 files from different workbooks to 1 Master file and with each file in different worksheet !!!
Thanks,
Senthil

[@pedrocampelo8925]

Did you open those 50 files to run the code?

[@manjuh4621]

Bhai VBA code kaise lenaa ??

[@nengtech6914]

awsome

[@shivangbedi1585]

Can you tell me how can I directly combine it in one sheet

[@MB-yw6rd]

Worked perfectly, Thank you!!

[@Exceljunction]

Thanks for appreciating. Please "like" and "subscribe" for more such useful videos.

[@chaosgoblin89167]

Thanks a MILLION for this! Made combining six different C-Suite excel files of goals and priorities into one SO much easier, and saved me so much time!!!

[@AntiFurryNatio]

I did my work in to different workbook and was pissed off

[@christychen1850]

Can you please share the code? I can not download it, it just wont work .

[@shankerachugatla1314]

In Description i didn't found any code. Can you provide me the code please.

[@qaisarali594]

Sir, I am extremely grateful to you for this video. I had to work on 400-plus workbooks which were kinda impossible, but now I did it in a matter of seconds. ⭐⭐⭐⭐⭐⭐⭐

[@jeannamaegalban2232]

Where did you get the VBA Code? The link isn't working on my end.

[@Exceljunction]

Glad it helped!

[@Exceljunction]

Please revisit the page and try downloading again. The issue has been fixed.

[@xiejn9634]

This works perfectly. Thank you for spreading the knowledge around ! 👍

[@12419784]

Extremely thankful to you. It worked like a miracle.
I was badly searching for this. I was having more than 200 different excel files which I wanted to get in a single excel workbook. Your VBA Code made it much easier. Thanks a lot again.

[@Mark-bq2ts]

where is the vba code to copy

[@pondururaghuram6816]

Can you send the vb script once

[@ayushmaharjan4632]

Vba patha na machikni randikoxoro dui jana le sodhisakyo k fuckijg shitheadsdd

[@serpilsanli9181]

That's great, much thanks for your help by sharing this to the world!

[@gracealmene3570]

You're a legend! Thank you so much for this video! You have me save a million of hours just consolidating worksheets!

[@Exceljunction]

Happy to help!

[@BIGGPHILL]

Lifesaver!!! Thank you so much for this!!

[@hoodfiona2886]

Thank you, brilliant, this worked well, so easy and clean and has been a big help. I also modified the code slightly to pick up .csv files instead of excel files. Now to find out how to merge all the tabs into one. It would be even simpler if the code was just pasted in the comments. Thanks again for posting such clear video.
There were no errors I found into the code, it worked perfectly the first time.

[@aasikahamed5664]

Please post the code for CSV

[@Manjunathsinghnath]

Can you please share the code which we need to put in code window

[@kevinpony3620]

didn't know this process contains such complected steps. thank you!

[@shifangli1009]

It works like miracle! Thank you!

[@Exceljunction]

Thank you ! Please do not forget to SUBSCRIBE the channel for more such useful videos.

[@seizuresaladventures]

Thanks for sharing your knowledge on this 👍

[@melissadavis1844]

This was a time and life saver! Thank you!

[@xuefang2858]

can i have the VBA code?

[@Exceljunction]

Apologies for the inconvenience. The link is working fine now. www.exceljunction.com/combine-multiple-excel-workbooks-into-one-workbook/

[@LuthoLawata]

This was so useful!! Thank you for this tutorial.

[@forcexdicas3827]

Obrigada! Ajudou muito 👌 estava horas buscando como fazer funcionar a macro

[@Exceljunction]

Glad it helped

[@mayalawlaqi6190]

Thank you for spreading the knowledge around!
Can you please provide us an explanation about the VBA code? For better understanding the code and not to just copy and paste it.
Thank you once again.

[@VIITEducation]

th-cam.com/video/b3wtw8WbfKk/w-d-xo.html

[@Exceljunction]

Yes, soon

[@ThyBlackWings]

It worked for me, I merged 184 files. In my case I had to modify the 4th line slightly, since I was merging .csv files. So I changed the .xls part to .csv and ran the script. Thanks a lot.

[@Exceljunction]

Thank you ! Please do not forget to SUBSCRIBE the channel for more such useful videos.

[@savivasup]

Thank you so much... without this comment I would have been still stuck! 🙌🏿

[@girishgk395]

Special thanks to you..

[@johnhenrywashington8369]

Maaaaannnn thank you for noting the change from .xls to .csv....was not working for me until i did that!! Thank you alot

[@NimeLime]

Where is the code?
I have to type Manually?

[@rewphixer]

Needed this badly? You saved me sooooo much future time. Very Grateful

[@Exceljunction]

Glad that you found it useful. Please do subscribe the channel for more such useful videos.

[@Exceljunction]

Link is given in the description

[@elizajoystamaria7122]

Thank you a lot. It helps me with my compilation of my grades.

[@Exceljunction]

Thanks for appreciating. Do not forget to "subscribe" our channel for more such useful videos.

[@9202100810]

Thank you, fully working on excel 365 2019

[@cminor8549]

It worked very well for me. Pay attention to the type of file you are trying to combine. The formulas provided are for 'xls' and 'xlsx'. use the proper formatting for the proper files and it should work well for you.
Thanks for the short cut!!!!

[@Exceljunction]

Cheers!

[@shankerachugatla1314]

In Description i didn't found any code. Can you provide me the code please.

[@Berghiker]

Just what I was looking for. Thanks.

[@Exceljunction]

Glad, could be of help.

[@sheldonthomas9946]

Worked perfectly, thanks.

[@teresasaterfield1985]

Amazing... thank you!! Greatly appreciated!!!!!

[@Exceljunction]

Thanks for appreciating.

[@MrCybyCY]

Hi
What if I updated something on my individual worksheets would be reflected to the MASTER worksheet also and vice versa ? or

[@Exceljunction]

No. You have to re-run the code for updations.

[@jamesscott6864]

@@Exceljunction does that mean i have to rerun the module ? but if i do that, will it update the data in the master workbook or it will recreate new worksheets to the one it already have ?

[@jamesscott6864]

Okay i tried it myself, it doesn't update, it creates new sheets

[@YepItsMaeh]

This is very helpful. Thank you for sharing!

[@Exceljunction]

Thanks for appreciating

[@lubomirstoytchev]

Nice and clean code that works! Thanks a lot!

[@nasibasharipova4287]

This is great! Thank you. Do you also have a code that takes three identical files and merges them into a new workbook under one tab. Let's say I have exactly the same sales report template that I send out to different sales districts, and then I need to combine those three sales reports into one worksheet? The headers are the same on all the files.

[@Exceljunction]

Try consolidate function

[@logantaylor6614]

superwoman

[@nadeemhussain6138]

@@logantaylor6614 Hi are you know about this function then kindly help us.

[@Exceljunction]

Yes. Plz refer to another video:
th-cam.com/video/ywC8AGl-AwU/w-d-xo.html

[@KEN_DEN]

Power Query. . . Does the same thing but without VBA

[@gopigk8057]

Sir, simply awesome. Along with this, if you explain code also step by step, it will help us to understand and learn the macro.. How to write and how to execute. Anyway thanks once again sir, for your knowledge sharing.

[@Exceljunction]

Thanks for your kind words. Will surely try explaining usage of VBA in upcoming videos.

[@shankerachugatla1314]

In Description i didnt found any code. Can help you help me..

[@pradeepkumar2607]

Thanks for the clear slow patient presentation. Looking up for more topics in excel.

[@Exceljunction]

Thanks for appreciating. Please do like and subscribe for timely updates.

[@KavyaKavya-vi8do]

Hey where can I get that code

[@esperancemutegwaraba3455]

Thank you for this helpful tutorial.

[@sultanayyubi1380]

from where did you get code..? that is not showing in your video.

[@Exceljunction]

Link to code is in the video description. However, you may check the code here: www.exceljunction.com/combine-multiple-excel-workbooks-into-one-workbook/

[@saikiransyan777]

we didn't get that code in that page Bro...!!!

[@oluwaseyipeterorodele8810]

Please Why am I getting compile error

[@shivamdoshi9805]

To all those facing errors, make sure the main Excel Folder with all files are in C Drive and Documents

[@shankerachugatla1314]

In Description i didnt found any code. Can you provide me please.

[@Cazessus1]

I Love yA!!! Thank you.... Worked great!

[@openmind2012]

Thanks it worked like a charm to combine multiple workbooks into one! Saves so much time instead of copying the sheets to a workbook.

[@Manjunathsinghnath]

Can you please share the code which we need to put in code window

[@Ankit12345689]

Whenever I run macro it shows error in
Sheet. Copy after:=Thisworkbook.sheets(1)
Please help

[@versusstats7051]

Try replacing sheet with x in the for loop

[@jamsajise6765]

I am having this error too

[@Ankit12345689]

Pls make video on it or explain this error.

[@prudhviraju1536]

@@Ankit12345689 I am also getting same error.

[@shailaja369]

Sheet.Copy After:=Thisworkbook.sheets(1)
After Sheet. you have kept an extra space and in word after "a" has to be Capital
the right format has typed above

[@anilbharadwajchivukula8879]

I tried many times, It's not working

[@Exceljunction]

Check if you're using the correct code XLS or XLSX and follow steps carefully. Let us know how it goes.

[@pikunessfilm]

I am doing xls. It's not working

[@kikenhood7609]

You saved my life dude!! thanks a lot!

[@Exceljunction]

Glad that we could be of help

[@estherndolo3890]

Thank you for this tutorial it was such a wonderful one and direct to the point.

[@Exceljunction]

Thanks for appreciating. Do like and subscribe our channel for more such videos.

[@amrendrakumar7255]

It's not working properly, I followed each trick 3-4 times.

[@Exceljunction]

Is this still an issue?

[@siddhidajha2847]

@@Exceljunction yes it is...

[@Excel10tutorial]

@@siddhidajha2847 Which excel version you are using?

[@Radhyakulshreshthablogs]

@@Excel10tutorial show the error is run time error 1004: I m usingexcel 2007

[@rosemwenjeri1004]

i have never been happier. This has been so helpful. Thankyou

[@Exceljunction]

I'm so glad!

[@faradhsingh6884]

Thank you so much! This was really helpful, all the way from South Africa!

[@Exceljunction]

Happy to help

[@2signus]

I had a code done that was not working for me and was because of the "\" at the end of the path, excellent video it went to the point and works, thank you!

[@Abonilla921]

Thank you for this video! You should share more videos like this!

[@Exceljunction]

Thanks for appreciating. Please do subscribe our channel for more updates.

[@RADHAKRISHNA-fv1ig]

It worked, Great! Thank you!

[@manolitasalagunting7032]

So very grateful here...it works like magic...thank you very much.

[@Exceljunction]

Thank you for appreciating. It encourages to do more useful stuff. Do not forget to "subscribe" the channel for updates.

[@voicesofwonderland]

Thank you for this. You made my day much better and saved me a lot of time!

[@angadunited]

Thanks mate!

[@user-nm4ul6gr6o]

Thank you very much for this wonderful code and for this simplified and clear method.

[@Nettwork007]

It works fantastic. Could you tell me what should I change in the code to copy only 1 specific worksheet istead all of them? Where should I implement the refernce workbook name? for example I would like to copy only WS-3a table.

[@abeerusman536]

Thank you! It worked.

[@peterphang4600]

OMG! works like charm, save me lots of time! Thanks bro! =D

[@Exceljunction]

Glad it helped. Don't forget to subscribe our channel for more such useful resources. :)

[@prachigupta2253]

Really helpful!!! Thank you so much

[@Exceljunction]

Thanks for appreciating

[@asadkabir4253]

It really helps. very well explained

[@leechengng1412]

Great info! Thanks much!

[@Exceljunction]

Thanks for appreciating. Subscribe this channel for more such useful videos.

[@b2u0y0f4n]

Thank you very much my friend!!!

[@Exceljunction]

You're most welcome !! Please do subscribe our channel for more such useful videos.

[@me41423]

excellent video. Worked like a miracle!!! thank you sir

[@Exceljunction]

Glad it helped

[@nyaluv143]

Helped a lot thanks !

[@sridharsivajisah8127]

Amazing work, thanks

[@simanchalasahu6859]

Thanks :)
Excel Junction

[@ellamontejo8683]

Nice!! Thanks a lot!

[@kds2710]

Thank you! It worked like magic... :)

[@Exceljunction]

Thanks for appreciating. Do not forget to "subscribe" our channel for more such useful videos.

[@shujaahmed08]

Please Subscribe me.

[@gosiahlasko3813]

Thank you very much. I received a code by email and it helpped me a lot with my assessment work.

[@Exceljunction]

Glad it helped!

[@amithkumar9094]

thank you man you rock

[@akshaydas7299]

Thank you. Was quite helpful...

[@Salimrsa]

This is awesome, Thanks. How to make worksheet name by ascending order like ws1,ws2,ws3 instead of ws3,ws2,ws1 in the video.

[@davidmwikisa953]

This is amazing. Great work

[@Exceljunction]

Thanks a lot!

[@elmardngicho6352]

This is so amaizing!

[@Exceljunction]

Thanks for appreciating.

[@pedroelton7040]

Man, this is amazing... God bless you!!! hahaahah

[@Exceljunction]

Thank you ! Please do not forget to SUBSCRIBE the channel for more such useful videos.

[@TuThuysanh]

very good it worked for me, thank you buddy

[@ziauddinkhan7718]

Really helpful!
Thank you!

[@Exceljunction]

Glad it was helpful!

[@abdulrehmanbaloch1811]

thanks a lot for such helpful tutorials

[@subratdhal7422]

Excellent.... Thanks you make my life easier

[@Exceljunction]

Cheers!!

[@nabilaumeer4534]

Thanks so much! God bless!
Can we consolidate data that have exact same headers from multiple files into a single sheet?

[@mathursvideos4082]

yes i will tell you

[@nabilaumeer4534]

@@mathursvideos4082 Yes Sir, go on.

[@MsOfficeLearning]

Thank you for a great tutorial !

[@xuefang2858]

can i have the VBA code ?

[@Exceljunction]

You are welcome!

[@hafizwaleedzafar8285]

Perfect. Thank You!

[@Exceljunction]

Thanks for appreciating

[@mohamed-ezz]

Thanks saved lots of work brother keep the spirit

[@matthewhenington8139]

You are a life saver!!

[@Exceljunction]

Cheers Matthew. Do subscribe to our channel for more such useful videos.

[@kathgomez1642]

It worked! Thanks!:)

[@Exceljunction]

Cheers !

[@sureshbabumk6509]

Thanks! code worked perfectly after removing one compile error, Space in the line "Workbooks (Filename) .Close"

[@mariannebeaulieu3600]

It works !!! Yahooooooo amazing =)

[@Exceljunction]

Great !

[@abdiazizmoalimhussein2348]

Thanks am new to this course but it is very interesting for us. when I want to compare two years budgets what is the simple method i use?

[@YaseenKhan-lp9ef]

Thanks for sharing your knowledge saved lot of time 👍

[@sashaleedouglas5760]

thank you are a life and time saver i'm at work, working with a million and one file at work and it was gettting super annoying

[@Exceljunction]

Glad that it helped you. Please do subscribe the channel for more such useful videos.

[@tueanhnguyen3799]

so amazing. thank you guy!

[@Exceljunction]

Thanks for appreciating. Do not forget to 'like' and 'subscribe' the channel.

[@kirkmcdonald4759]

Very helpful code! I am having one problem I can't figure out: The Filename variable is always set to "" so the code stops running before opening any files. I have copied the code exactly (Filename = Dir(Path & "*.csv")). Is it because these are text files? Any ideas are much appreciated!

[@praagnikas4362]

Thank you it worked for me .

[@lourenscc]

Wonderful! Wel done man!

[@Exceljunction]

Thank you

[@mushibhat09]

It realky helped. Thanks a lot

[@AishHumairaa]

Thank you so much ! You earned a subscriber 😉

[@Exceljunction]

Glad you found it useful :)

[@keithsellers8562]

Excellent, thank you, got it to work, no problems. If I only want to include the first worksheet of each of those workbooks, is there one more line of code to add?

[@Exceljunction]

+Keith Sellers Thanks for appreciating. Do not forget to "like" and "subscribe" the channel.
Will look into your follow-up query and get back.

[@yogeshkhant9684]

it's very nice working my one day work is do by this technique in one hover.

[@mdshojibhossain1205]

This is great! Thank you.

[@Exceljunction]

Glad you liked it!

[@RSDubey-oe1ig]

Wow excellent video thank you Sir.

[@Exceljunction]

+ramashankar dubey Thanks for appreciating. Do not forget to 'like' and 'subscribe' the channel.

[@tariqa8962]

I love you!!! you're a life saver

[@Exceljunction]

Glad it helped

[@elizabethspehr4146]

THANK YOU!!!

[@Exceljunction]

Most welcome. Please like and subscribe our channel for useful updates.

[@elizabethburley7954]

Thank you!

[@abdulhamidalhaddadi2255]

Thank you, nice lesson

[@jupinmaniya5234]

Great
Thank you for sharing.