Combine Multiple Sheets from a Folder to create a masterfile

[juggernaut24]

Hello experts, I do have excel files (1 sheet per file but headers are different) to download everyday. I need to transfer them into a masterfile (grouped into sheets) then the process will repeat the next day but the masterfile is still the same.

Basically the new values will be pasted to the last values from yesterday to all of the sheets.

can this be done using vba?

Thank you!

 

[rlv01]

can this be done using vba?

If you are able to code a VBA macro , then yes it is possible.

 

[juggernaut24]

thanks for the reply, do you have a vba code that works?

First run, all files from the folder will be transferred to the masterfile, copying the sheetname from the the files (always in sheet 1)

Next Run (tomorrow), the contents per sheet should just be stacked with new values per sheet. It should look for the correct sheetname before pasting the new values

i explored power query but limitation for that is all columns should be the same name and number

Your help would be very much appreciated, thank you

 

[rlv01]

thanks for the reply, do you have a vba code that works?

Sorry, no I do not. You obviously have a lot of custom requirements for what you want to do. And while you will be able to find many VBA examples of combining several workbooks into one big (master) workbook, because that is a common theme, all of them will have been designed to meet someone else's custom requirements. However, if you have some ability in VBA programming, you can use those examples to guide you in creating your own custom solution.