Merge data from other Excell files by copying (only) data into Master matching to Headers.

[paulc869]

Hei to all

I have the below code to merge the excel files. It works perfect.

However I have small issue with this code.
When I run, it copy both data and the header from other file, and replaces the headers in Master file. Thus I am loosing some header data in master file.

Master file have all headers and I need to copy only the data from other files and paste in the master file matching to the headers.
Other data files have limited headers with data. I need to pull only data from those files and paste to the column heads in the master file, which matches to the header.

Please, any help is highly appreciable.

Thank you very much.
paulc

Please Login or Register  to view this content.

[dflak]

Here is my shot at it.

On the control panel sheet you identify two directories:
- Cell B1 is the "in Basket" - enter the path name of the folder containing the files to be processed.
- Cell B2 is the "Out Basket" - enter the path name of the folder where you want the files to be placed after they are processed.

Clear the data on the summary sheet rows 7 and below if you wish and click the button. Data will be appended unless it is cleared manually.

[paulc869]

Than you very much for your help.

However there is message box showing me the ID number which is not available. There is thousands of data to merge.
So this message is annoying for long time.

How can I skip this message.

[jindon]

1) Mark as "Solved" your original thread.
Merging four or more Excel files into one, which has unique column heads

2)

Please Login or Register  to view this content.

[dflak]

Here is the same file modified (not tested because I no longer had the test data), Instead of popping up a dialog box on not found, it writes them to a log sheet called "Not Found."

[paulc869]

Thank you very much helping in this case. Great help.