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
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. ⭐⭐⭐⭐⭐⭐⭐
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.
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.
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.
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.
@@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 ?
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.
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!!!!
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/
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.
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
Thank you for this amazing VBA code. Is there a way to edit the code to get a specific sheet with the same name in all workbooks (it may not be the first sheet, but have the exact same name across all files). Thank you.
Please join our WhatsApp / Telegram group and post your query there for quick resolution; links below: WhatsApp Group: www.exceljunction.com/whatsapp-group/ Telegram Group: www.exceljunction.com/whatsapp-group/
so would I be able to now send this merged workbook to someone and it work on their computer - or do they need the original file folder (the path) as well ?
Please join our WhatsApp / Telegram group and post your query there for quick resolution; links below: WhatsApp Group: www.exceljunction.com/whatsapp-group/ Telegram Group: www.exceljunction.com/whatsapp-group/
So the challenge now is the code that was written on word doc. Do I need to just copy what you have written already or can one just generate his as long as you know how to write codes?
Although you're limited to 255 sheets in a new workbook, Excel doesn't limit how many worksheets you can add after you've created a workbook. The only factor that ultimately limits the number of worksheets your workbook can hold is your computer's memory.
Thank you so much. One question, if we do any changes in one workbook, would it automatically be done in master file. like if it is saved in shared folder, and one person has made any changes in one worksheet, and the manager is only seeing the master one, so would it automatically be done in master one or not? thank you again.
When you combined the workbooks, did create tabs of each file you combined? I want to combine only specific rows from specific separate workbooks, example: combine the text found on row B2 and placed on the master, and do the same with next workbook. Example project. I have a survey with 100 responders, each responder is one file where the responder select answer located on B2. I want this way so can calculate all the answers from each responder in same workbook. I could do this in google forms that would do the job. But I dont want to use google forms because sometimes I don't have access to the drive google.
Thanks it works, but when it combined the different workbooks it didnt save the name of each workbook in the tabs at the bottom for each workbook. Is there a fix for that? Its hundreds of workbooks without specific names so not easy to just go in and rename
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!
When I follow the link and ask for the code via email I only get an email asking me to join the newletter. I do not want to join the news letter I was hoping to get the code only.
Joining newsletter is not a compulsion. You can even unsubscribe anytime. And in anycase, none of the subscribers are ever disturbed... If at all, they only benefit from the articles sent. Anyways, choice is entirely yours.
@@Exceljunction I understand this but under "Download VBA Code for XLSX files " it asks for name and email, I have filled it out three times, and received three join newsletter requests but no copy of the code.
I’m trying this out but I’m coming up with a debug issue run time error ‘52’: Bad file name or number. If I press the Dbug button it highlights the line filename = DIR (Path. & “* .xls”) All my file names that I’m trying to import into one workbook has an extension of .xls. I am using the exact code that you created because I cut and pasted it in and changed the path to the pathware the files are located and I did add the \ before the parentheses. Can you please help me to figure out how I can get this to work.
Is it possible to combine the same sheet from different file.? For example, My excel file has 10 different worksheets in it. I need to combine a specific sheet' from multiple excel files into a single worksheet. Is that possible.? Please help.!!
Please join our WhatsApp / Telegram group and post your query there for quick resolution; links below: WhatsApp Group: www.exceljunction.com/whatsapp-group/ Telegram Group: www.exceljunction.com/whatsapp-group/
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
Did you open those 50 files to run the code?
Bhai VBA code kaise lenaa ??
awsome
Can you tell me how can I directly combine it in one sheet
i have never been happier. This has been so helpful. Thankyou
I'm so glad!
Video Starts at 2: 50 mins
More than Video , your Comment Helped me 😃😃
Thank you so much! This was really helpful, all the way from South Africa!
Happy to help
Thanks for the clear slow patient presentation. Looking up for more topics in excel.
Thanks for appreciating. Please do like and subscribe for timely updates.
Hey where can I get that code
Needed this badly? You saved me sooooo much future time. Very Grateful
Glad that you found it useful. Please do subscribe the channel for more such useful videos.
Link is given in the description
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. ⭐⭐⭐⭐⭐⭐⭐
Where did you get the VBA Code? The link isn't working on my end.
Glad it helped!
Please revisit the page and try downloading again. The issue has been fixed.
This was a time and life saver! Thank you!
can i have the VBA code?
Apologies for the inconvenience. The link is working fine now. www.exceljunction.com/combine-multiple-excel-workbooks-into-one-workbook/
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
Glad that it helped you. Please do subscribe the channel for more such useful videos.
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.
Thank you ! Please do not forget to SUBSCRIBE the channel for more such useful videos.
Thank you so much... without this comment I would have been still stuck! 🙌🏿
Special thanks to you..
Maaaaannnn thank you for noting the change from .xls to .csv....was not working for me until i did that!! Thank you alot
Where is the code?
I have to type Manually?
Thanks You have saved my lot of time
Glad that it helped
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.
where is the vba code to copy
Can you send the vb script once
Vba patha na machikni randikoxoro dui jana le sodhisakyo k fuckijg shitheadsdd
Thank you very much. I received a code by email and it helpped me a lot with my assessment work.
Glad it helped!
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.
Please post the code for CSV
Can you please share the code which we need to put in code window
Thank you so much ! You earned a subscriber 😉
Glad you found it useful :)
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.
ruclips.net/video/b3wtw8WbfKk/видео.html
Yes, soon
You're a legend! Thank you so much for this video! You have me save a million of hours just consolidating worksheets!
Happy to help!
Hi
What if I updated something on my individual worksheets would be reflected to the MASTER worksheet also and vice versa ? or
No. You have to re-run the code for updations.
@@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 ?
Okay i tried it myself, it doesn't update, it creates new sheets
I love you!!! you're a life saver
Glad it helped
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.
Try consolidate function
superwoman
@@logantaylor6614 Hi are you know about this function then kindly help us.
Yes. Plz refer to another video:
ruclips.net/video/ywC8AGl-AwU/видео.html
Power Query. . . Does the same thing but without VBA
Thank you for the code worked great
Glad to know it worked for you. Please subscribe for more such useful videos.
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!!!!
Cheers!
In Description i didn't found any code. Can you provide me the code please.
So very grateful here...it works like magic...thank you very much.
Thank you for appreciating. It encourages to do more useful stuff. Do not forget to "subscribe" the channel for updates.
This works perfectly. Thank you for spreading the knowledge around ! 👍
yo bro
thanks for making life ezy eyh.
truly thankful.
It's my pleasure
Worked perfectly, Thank you!!
Thanks for appreciating. Please "like" and "subscribe" for more such useful videos.
You are the best Bro , Thank You
I tried many times, It's not working
Check if you're using the correct code XLS or XLSX and follow steps carefully. Let us know how it goes.
I am doing xls. It's not working
thanks a lot for such helpful tutorials
from where did you get code..? that is not showing in your video.
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/
we didn't get that code in that page Bro...!!!
Please Why am I getting compile error
This video is awesome 🙂
👍👍👍👍👍👍👍👍
Thanks for appreciating.
Lifesaver!!! Thank you so much for this!!
Very Useful video thank you
Thanks for appreciating
Thank you, fully working on excel 365 2019
It worked! Thanks!:)
Cheers !
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.
Thanks for your kind words. Will surely try explaining usage of VBA in upcoming videos.
In Description i didnt found any code. Can help you help me..
It was very helpful. Thank you
You're welcome!
To all those facing errors, make sure the main Excel Folder with all files are in C Drive and Documents
In Description i didnt found any code. Can you provide me please.
excellent video. Worked like a miracle!!! thank you sir
Glad it helped
Whenever I run macro it shows error in
Sheet. Copy after:=Thisworkbook.sheets(1)
Please help
Try replacing sheet with x in the for loop
I am having this error too
Pls make video on it or explain this error.
@@Ankit12345689 I am also getting same error.
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
It"s working Great!! Thank you so much.
Thanks for sharing your knowledge on this 👍
Thanks for sharing your knowledge saved lot of time 👍
Amazing... thank you!! Greatly appreciated!!!!!
Thanks for appreciating.
Thanks dude it helps me so much God bless.
Glad it helped. Plz do subscribe our channel for more such useful videos.
It's not working properly, I followed each trick 3-4 times.
Is this still an issue?
@@Exceljunction yes it is...
@@siddhidajha2847 Which excel version you are using?
@@Excel10tutorial show the error is run time error 1004: I m usingexcel 2007
excellent sir.. you helped me to save lot of efforts and time.
Glad you found it useful. Stay connected for more such useful stuff.
Thank you for a great tutorial !
can i have the VBA code ?
You are welcome!
Thank you sir.. Works for me and it's very helpful... Keep up... 👌👌👌
Glad you found it helpful. Please do subscribe our channel for more such useful resources.
Thankyou for your help it worked !
amazing, nice tutorial
Thanks for appreciating. Do subscribe the channel for more such useful resources.
This is awesome. Will I be able to edit the data and save in those individual sheets from the master workbook?
Thanks
And no, you have to rerun the code for changes to reflect.
I dont see the code? Where can I find it
Thank you bro. Its really help me. 😁
Glad to know that
Thank you very much, the code worked for me and I am super happy right now 😁😄😝😝
You're welcome!
I'd love to know if is it possible to do it but with the excel workbooks in separated folders and not together.
Post your query on our Whatsapp/ Telegram group.
Thank you it worked for me .
Well I love this it time saving and easy. Though I still need help on the VBA code. I am completely stuck. How to you get the code?
Thank you
Restored. It's working fine now. Apologies for the inconvenience.
Thank you for this amazing VBA code. Is there a way to edit the code to get a specific sheet with the same name in all workbooks (it may not be the first sheet, but have the exact same name across all files). Thank you.
You may put across the requirement in our WhatsApp/ Telegram group (link on website)
Please join our WhatsApp / Telegram group and post your query there for quick resolution; links below:
WhatsApp Group: www.exceljunction.com/whatsapp-group/
Telegram Group: www.exceljunction.com/whatsapp-group/
Thank you very much it's working 😊❤
Very Good.. Thanks for Sharing.. Subscribed :)
Thanks for the sub!
Wow! that worked 👍🏼👍🏼
Gr8 :)
Thank you! It worked like magic... :)
Thanks for appreciating. Do not forget to "subscribe" our channel for more such useful videos.
Please Subscribe me.
This this helps a lot and if it is having cell reference based on that Excel sheet combine
Thanks
so would I be able to now send this merged workbook to someone and it work on their computer - or do they need the original file folder (the path) as well ?
OMG! works like charm, save me lots of time! Thanks bro! =D
Glad it helped. Don't forget to subscribe our channel for more such useful resources. :)
Sir, is there a way to combine data from the files onto one single sheet instead of multiple sheets?
That can be done using consolidate function
Does it help to insert an excel sheet whose cells have referances to another excel sheet?
You need to try it out on a sample file.
Thank you very much for this trick ❤
It worked! Thanks
Glad! Plz subscribe for more such useful videos.
Can we restrict the sheet name of all workbooks which have to be copied. Please please help me for this
Please join our WhatsApp / Telegram group and post your query there for quick resolution; links below:
WhatsApp Group: www.exceljunction.com/whatsapp-group/
Telegram Group: www.exceljunction.com/whatsapp-group/
So the challenge now is the code that was written on word doc. Do I need to just copy what you have written already or can one just generate his as long as you know how to write codes?
Question not clear
Can we give the cell reference instead of path, coz if the path changes then we should change it in the module where we give the code
Yes. Code needs to be modified for that.
While clicking that Green icon in VBA, receiving a notification to add Macro.. Can you please let know how to do that
Enable macro and proceed
It works !!! Yahooooooo amazing =)
Great !
Hello Sir I can not see the VBA CODE you said has been shared in the detail section... thank you for the video it has been helpful
Yes, link is in the video description
Nice video
Thank you sir
I want to ask you
1. How many work book we can add, is there any limit??
Although you're limited to 255 sheets in a new workbook, Excel doesn't limit how many worksheets you can add after you've created a workbook. The only factor that ultimately limits the number of worksheets your workbook can hold is your computer's memory.
@@Exceljunction
Once again thank you sir
I m really very happy to see your reply
Most of the people don't reply,
Great sir
God bless you
Thanks
Thanks for the kind words. Please do subscribe to our channel for more such useful videos.
very good it worked for me, thank you buddy
this is very very great ! Thk U!!!
Glad you like it!
Your are a gem 💎...
Thank you thank you so much 🥰
Thanks for appreciating. Plz do subscribe our channel for more such useful videos.
@@Exceljunction I'm using it in my daily work sheets
That's great 👍
Thank you so much. One question, if we do any changes in one workbook, would it automatically be done in master file. like if it is saved in shared folder, and one person has made any changes in one worksheet, and the manager is only seeing the master one, so would it automatically be done in master one or not? thank you again.
No you will have to rerun the code
Good Video, really Helpful. Thank you
Glad it was helpful!
kya VBA code ko write karke daal sakte h
kaam karega kya ?
When you combined the workbooks, did create tabs of each file you combined? I want to combine only specific rows from specific separate workbooks, example: combine the text found on row B2 and placed on the master, and do the same with next workbook. Example project. I have a survey with 100 responders, each responder is one file where the responder select answer located on B2. I want this way so can calculate all the answers from each responder in same workbook. I could do this in google forms that would do the job. But I dont want to use google forms because sometimes I don't have access to the drive google.
Thanks saved lots of work brother keep the spirit
what if 2 files have same sheet names.. will it append to one sheet ? or create another sheet with count as sheet (1) ??
It won't append to one sheet
Thanks it works, but when it combined the different workbooks it didnt save the name of each workbook in the tabs at the bottom for each workbook. Is there a fix for that? Its hundreds of workbooks without specific names so not easy to just go in and rename
would be nice if you could type the code in the description there is something wrong with the code when i type it in and i don't know what it is
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!
Sir can i merge together all the data from different sheets into one sheets while not adding the duplicates ??
When I follow the link and ask for the code via email I only get an email asking me to join the newletter. I do not want to join the news letter I was hoping to get the code only.
Joining newsletter is not a compulsion. You can even unsubscribe anytime. And in anycase, none of the subscribers are ever disturbed... If at all, they only benefit from the articles sent. Anyways, choice is entirely yours.
@@Exceljunction I understand this but under "Download VBA Code for XLSX files
" it asks for name and email, I have filled it out three times, and received three join newsletter requests but no copy of the code.
@@Exceljunction Thank you for your help, the newsletter requests just came in first, the requested file emails just came in.
@@redb.5533 have u got vba
@@redb.5533 plz share with me i m nt able to open
I’m trying this out but I’m coming up with a debug issue run time error ‘52’: Bad file name or number. If I press the Dbug button it highlights the line filename = DIR (Path. & “* .xls”) All my file names that I’m trying to import into one workbook has an extension of .xls. I am using the exact code that you created because I cut and pasted it in and changed the path to the pathware the files are located and I did add the \ before the parentheses. Can you please help me to figure out how I can get this to work.
See the steps very carefully, including the path. Is there a "/" at the end?
Great..... It's working. but i have a small doubt ....... is it auto update or.......?
No, it's not auto update. You need to run it again to update.
The link is not working. Could someone help me with the VBA Code?
Which Excel are u using it Sir...i couldn't find the option only
Is it possible to combine the same sheet from different file.?
For example, My excel file has 10 different worksheets in it. I need to combine a specific sheet' from multiple excel files into a single worksheet. Is that possible.?
Please help.!!
Please join our WhatsApp / Telegram group and post your query there for quick resolution; links below:
WhatsApp Group: www.exceljunction.com/whatsapp-group/
Telegram Group: www.exceljunction.com/whatsapp-group/
Wow it worked,thanks 👍
Thank you for this tutorial it was such a wonderful one and direct to the point.
Thanks for appreciating. Do like and subscribe our channel for more such videos.
It worked like pro 😎😎
Glad to know it worked for you.
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?