Merge Workbooks to Master Workbook

[donb1337]

Hi guys,

at the moment I'm trying to consolidate four Workbooks to a Master Workbook.

The four Workbooks I want to merge have the same table structure but except the "Project Number" they have almost different data in their columns.

What I want to do is creating a Master Workbook in which all the Projects are listed once with the information of all four Lists.


I think I know what to do but I don't know how to do it...


While consolidating the data should be checked whether it is already in the Master Workbook or not:
If yes the Macro should copy the adding data in the existing Project row and there in the correct column.
If not the Macro should create a new row for the Project. <- So there should be something like "+1".

I think the problem could be to define in which column what information should be copied.
At the moment I already set header in the Master Workbook. Does that makes sense or is there a smarter way to simplify it?
The point is that I should be able to control which data will be copied in which column.

To make it easier for you to understand what I'm talking about I created an Example file in which the four Workbooks plus the Master Workbook are and attached it.


Any kind of help is really appreciated! Thanks in advance!