Merging Data of two file into one

[Anmol_happy]

I want to merge files "Data" which are in "select input folder"button and "select output folder"button into one file
Both the files "Data" Should Merge When I click Execute button
Is there any macro to dd?please help me out

 

[Joe4]

"Merging" files can mean different things.
For example, it could mean taking the sheets from one file, and copying them into new sheets in the other file.
Or, it could mean taking all the data from one file, and pasting it to the bottom of the data of the other file.

So, we kind of need to know the following:
1. How many sheets are in each file (is it only one, or multiple)?
2. What is the structure of the data? Is it exactly the same in both files?
3. How exactly are these files to be merged (see questions at the beginning of this reply)?

Quite often in these cases, it is helpful for us to see examples of what the data looks like in each file, and what the expected output should look like.