Excel VBA to Combine Multiple Workbooks - Transfer Data from Multiple Excel Files

This tutorial explains how to transfer Data from multiple excel workbooks into one Master File with easy VBA Code.

[wenkev]

Do you have a video for this? I do all my estimates on an Excel spreadsheet. The cells that the address goes in is the same for all my saved estimates. I would
like to collect the addresses from all my estimates and place it in one file for mailing. Can you help with this?

[MohAboAbdo]

Thank you very much for this great video.

[johnenojardo]

Superb just what I need! Many thanks man!

[JCROD]

Thanks for the video. It worked beautifully

[uday]

I m dealing with network alarms on daily basis.

Getting data in 23 files for different zone.

Need to append the data in single sheet for doing further analysis.

[tuhin]

Hi,
This is great to use but I need little help with the code as my data has few missing count of files names can I skip them in the loop.
E.g.: The file name is "Search Query Week 6.xlsx", then Week 7 and 8 is missing then "Search Query Week 9.xlsx" it's one thing i want to know how to jump if the file is not exist.
Another thing is my file name ends with 6 to 35, hence should I use "i" as shown in the video or need to do some changes with the code.
These 2 queries.
I must say the video was very useful.
Thanks a lot for this.

[rajadey]

Ok if I will go with macro and doing the same things let's replaced the vba codes then what is the results? That will work?

[prashantsureshkatkar]

Hi, your video is so helpful to me. But I stuck at one point in raw files after the header I have one black row and after that blank row I have data.. will you please tell me how to edit the code in this condition.. please guide. That will solve my entire problem

[belmondo]

Can we just take particular data from each file? If yes, how we can do that? (For example in this example, we just need column A and column D, can we do that?

[atulojha]

Thanks for such video tutorials.
Can you please describe how to set file location if details are not be same eg . Dpr -1, 2, 3...
And second thing how to use columnoffset if there is column are not fixed in order.

[PeggywongPeggy]

my file it is totally diff, mine is staffs salaries / taxes i need to run for the whole years to file govt tax how to do the run.

[saimahmad]

Thank you for this video and it was really helpful.
I am trying to achieve the same thing but instead of pasting everything in first sheet of master file, I want separate sheets of each excel data in the master file.
How can I do that? Any help will be appreciated.

[vsbabu]

Hi Sir, Could you please help me on VBA code for below scenario..I have a folder which is having multiple files, in that few files having 15 columns of headers and few of files having more than 32 columns of headers, , so if file has 15 columns of headers need to copy as it is and paste into consolidated file, if file has 32 columns of headers need select required columns (up to 15 columns which are having same in 15 columns file but header name will be slight different ..example: if header name in 15 columns of the file has "Subject" but in different file header will be "SubjectID")which was align in between the headers, and paste into same consolidated file next available empty rows, , Thank you so much in advance...

[eleanortay]

In the video you had showed the combining of 5 different files, but what if you had an unknown number of files to combine? e.g. one week is 4 files, the next week is 5 files, the following week is 6 files etc. How do you modify the code for the "For i = 1 To 5 Step 1" part?

[Jojosmith]

excellent. thank you so much for your valuable lesson. Subscribe and very much liked !

[fengfuxu]

thank you for the video. I have a question for Printer object and Printers object. is any Reference library required to install in the Tool->Reference before we can use Pinter and Printers object? I run below code, and get error "object is required" for line "For Each prt In Printers".
Sub ListPrinters()
Dim prt As Printer
For Each prt In Printers
Debug.Print Prt.deviceName
Next prt
End Sub

[LaCarnevali]

Hi! Many thanks, this video has been really useful! It would be helpful also to know how to keep table formatting?
Thanks :)

[DJDEEM]

Hello. I recreated your Excel VBA to Combine Multiple Workbooks example shown here and I am receiving a Run-time error '1004': It's look for a file entitled "Day0.xlsx" but that file does not exist. Do you have any suggestion to fix this? Thanks

[rvp]

thanks for this video.. how to specify if i have more than 5 sheets in a folder. it would be great to know this for my work

[reeteshism]

Hey there... These codes are very useful. However, is there a possibility that you can tell me how to set up the code or what changes to make in this code shown in the video, if the file names are completely different.