Merge Multiple Excel Workbooks with Macro

Hi all,

I am stuck and would really appreciate your help in this regard, and I thank you in advance!:

I need to write an app in excel that will merge multiple excel workbooks into one workbook (this could possibly be a macro / or vba UserForm containing the process that reads the workbooks and copies the data across).

Important: The process must not create or copy duplicate records. I will have a unique identifier field (GUID) for each record in each workbook.

I don't have anything to work off at this stage, so really appreciate your help!

Thanks!

Hi patel45

Thanks for the share! Some great stuff on both these sites!

I think I have found what I was looking for here: http://www.rondebruin.nl/win/s3/win008.htm, BUT

I want the Macro process to verify that each record is unique (almost like a vlookup) whilst consolidating the sheets/workbooks. Do you have something like this, or could you perhaps give me some pointers?

@arlu1201 and patel45, thanks, removing the duplicates works perfectly!

I hope you guys would be able to assist me even further. I have tried the code myself, but get syntax errors etc. i would like to do the following:

1. Set the range to the whole sheet and not just a section;
2. Include the source Name of the workbook and sheet where the record was merged from;
3. Instead of merging ALL workbooks in a directory, I would like to select the workbooks to be merged.

I have attached my workbook with the code I currently have. Module 1 is the code for my button on sheet 1, as well as my Master code. FYI Module 2 contains code from Ron de Bruin with the functionality I need as listed above, i just cant get it combined correctly.

Thanks a lot!

Hi patel45,

it does give me the option to select the files - thanks. But It does not contain the rest of the functionality I had. I still need the following:

1. moving of consolidated workbooks to the "Import" directory;
2. Importing the data to the "Master" sheet;
3. Removing duplicates;
4. Other selections.

My Master code - Module 1 - works well, but I would like the following additions to make it better:

1. Set the range to the whole sheet and not just a section;
2. Include the source Name of the workbook and sheet where the record was merged from;
3. Instead of merging ALL workbooks in a directory, I would like to select the workbooks to be merged.