What can I say ? Crystal clear explanation of a very useful code. Your comments while writing the code helps me understand how VBA works. I find it very helpful. Thank you
Thanks, this is great. I have been looking everywhere for something like this. I love that you explain what the code does, it helps to modify it to what you need it for. Thanks again.
Joining multiple excel files with multiple sheets/every file, the resulting data file is directly put into a single sheet (the files to be joined have the same structure, and the title starts from A1), how to use VBA? Hope you make video tutorial about this problem
Clear, concise, and informative as hell. If I could give this more than one like I would. Do you know of any way to open files that are not workbooks? Like PDFs or other file types?
@ChesterTugwell - this is great, but how would I make this code dynamic where the user would select the folder where their Excel files have been saved? Also, how would I adjust the sort to sort by worksheet name?
Thanks for helping. can i take partial workbook name for worksheet. For example i have 100 workbooks with the name of different supplier like. Nestle ltd, coco cola beverage ltd, PepsiCo industry. I want to copy 2nd worksheet from workbook and I need partial name for worksheet like nestle, coca cola, PepsiCo. Please help.
Hi Chester, question, what if I have a long file name (Super Chester Tugwell File 01 T-1234 00) and I want to remove the first 3 words to be the new file name? Hope you can help
hi chester i followed your tutorial and i may encounter some error mostly its subscript out of range, although i have specified the correct path and everything
Thanks for video . Code working fine but my question is that if files in the folder are of different names then what amendment will be in code. Please reply ...
Hi Chester. Very well explained. Is it possible to have the entire workbook as a tab along the bottom of the workbook. i have 7 sheets per workbook and 11 workbooks that i wish to put in a master file
I need code to collect data from different workbooks books in folder and copy each relevant sheet in master file. I have three different file in folder and have 3 works sheets in each file. I need to loop through each file and copy relevant sheet to relevant master file. Than data from next file to master workbook. Waiting for reply, please Naeem
@@ChesterTugwell this good. The method will copy after sheets. I need to have different data. In main collection sheet i want to collect the data on available sheet only. I.e. if in collection sheet i mention three sheets Feb, aug and october so in the folder i need to open each file and first select the feb data then copy to collection sheet than the codr must search for aug than copy and than oct and close the file. After date from path second file to be open collect the required month data and close. When i change the month in collection sheet or change the sheet name the loop must search the collection sheet date in each path file. I hope i clarify. Need your guidancr
Hi, thanks for the video. I want a solution to combine selected sheets of many workbooks in 1 workbook. for example i have 2 files: File 1 - Part1.xlsx (Sheets - Part1_Data,Chart) File 2 - Part2.xlsx (Sheets - Part2_Data,Chart) I want to put Part1.Data and Part2.Data sheets in 1 new Excel file (Don't want to copy in workbook having code, it should be separate). Can it be done? Please share the code
What can I say ? Crystal clear explanation of a very useful code. Your comments while writing the code helps me understand how VBA works. I find it very helpful. Thank you
Thanks, this is great. I have been looking everywhere for something like this. I love that you explain what the code does, it helps to modify it to what you need it for. Thanks again.
Brilliant code and explaination, thank you so mych Chester. I checked several videos on RUclips and your code is the only that works so far.
This was really helpful and straight to the point , thank you.
Thank you very much for this code in my work I need combine 214 file....This served me well 🏆🏆
Hi, this really helps me a lot. But how to change the code to sorting according to the initial letter of the file.
Joining multiple excel files with multiple sheets/every file, the resulting data file is directly put into a single sheet (the files to be joined have the same structure, and the title starts from A1), how to use VBA?
Hope you make video tutorial about this problem
Thanks Chester. That's really very informative, very practical, and very excellent.
Clear, concise, and informative as hell. If I could give this more than one like I would. Do you know of any way to open files that are not workbooks? Like PDFs or other file types?
@ChesterTugwell - this is great, but how would I make this code dynamic where the user would select the folder where their Excel files have been saved? Also, how would I adjust the sort to sort by worksheet name?
Great video! Can I ask, what is the benefit of merging files this way, and not through power query combine and transform function?
Hey can you give me the code to combine all sheets in a workbook into a single sheet in a new workbook
Really helpful sir... Thank you very much.
how to combine multiple excel files or multiple sheets into one excel file but multiple sheets?
Thanks for helping. can i take partial workbook name for worksheet. For example i have 100 workbooks with the name of different supplier like. Nestle ltd, coco cola beverage ltd, PepsiCo industry. I want to copy 2nd worksheet from workbook and I need partial name for worksheet like nestle, coca cola, PepsiCo. Please help.
Hi Chester, question, what if I have a long file name (Super Chester Tugwell File 01 T-1234 00) and I want to remove the first 3 words to be the new file name? Hope you can help
1. What does "after:" do?
2. Dir will list the files into an array?
hi chester i followed your tutorial and i may encounter some error mostly its subscript out of range, although i have specified the correct path and everything
Thanks for video . Code working fine but my question is that if files in the folder are of different names then what amendment will be in code. Please reply ...
do you find it? I am working on it right now!
I also need this answer
Removed your counter variable as I don't need it, but it's applying ..xls to the end of the file name in the tab. How can I keep that from appearing?
Hi Chester. Very well explained. Is it possible to have the entire workbook as a tab along the bottom of the workbook. i have 7 sheets per workbook and 11 workbooks that i wish to put in a master file
Hi Andrew, you would have to have 77 sheets, If I understand you correctly
@@ChesterTugwell Yes
@@ChesterTugwell Yes 77 Sheets
Hi mine cannot work
Do While File ""
Workbooks.Open FolderPath & File
ActiveWorkbook.Worksheets(1).Copy _
after:=ThisWorkbook.Worksheets(ThisWorkbook.Worksheets.Count)
ActiveSheet.Name = Replace(File, ".xlsx", "")
Workbook(File).Close
File = Dir()
Loop
For i = 1 To 12
Worksheets(MonthName(i, True)).Move after:=Worksheets(Worksheet.Count)
Next
End Sub
does it will work with CSV format file?
hi how to add in the header in the active wb
This is great. Thanks for the explanations
Thanks a lot for your ideas!
No worries!
thanks for ur video & vba code
You're welcome!
I need code to collect data from different workbooks books in folder and copy each relevant sheet in master file.
I have three different file in folder and have 3 works sheets in each file. I need to loop through each file and copy relevant sheet to relevant master file. Than data from next file to master workbook. Waiting for reply, please Naeem
ruclips.net/video/sOyxlkzWIqs/видео.html
@@ChesterTugwell this good. The method will copy after sheets. I need to have different data. In main collection sheet i want to collect the data on available sheet only. I.e. if in collection sheet i mention three sheets Feb, aug and october so in the folder i need to open each file and first select the feb data then copy to collection sheet than the codr must search for aug than copy and than oct and close the file. After date from path second file to be open collect the required month data and close.
When i change the month in collection sheet or change the sheet name the loop must search the collection sheet date in each path file. I hope i clarify. Need your guidancr
@@mananaeem what if the file name is not on the month name
Hi, thanks for the video.
I want a solution to combine selected sheets of many workbooks in 1 workbook.
for example i have 2 files:
File 1 - Part1.xlsx (Sheets - Part1_Data,Chart)
File 2 - Part2.xlsx (Sheets - Part2_Data,Chart)
I want to put Part1.Data and Part2.Data sheets in 1 new Excel file (Don't want to copy in workbook having code, it should be separate).
Can it be done? Please share the code
You are amazing
so I tried to do it :) my code didn't work XD but I tried