Master excel that is updated by; and updates other excel files in folder.

[gertrudegertjan]

Hello,

I have multiple excel files inside a single folder named "X". All those excel files have the same first row with the name of the columns.
The different columns of the first row are : identifier 1/ identifier 2 / characteristic 1/characteristic 2/ characteristic 3 / characteristic 4 / characteristic 5 / characteristic 6/...

I would like to make one of these excel files the "master document" that is updated with the data from the other excel files of folder X and that, afterwards updates the appropriate cells in the secondary file in return. I'd like this to happen sequentially : first with secondary 1, then with secondary 2, then with secondary 3,...

Column 1 is called "identifier 1" and column 2 is called "identifier 2". The combination of the two is unique (but sometimes only identifier 1 is known, sometimes only identifier 2 is known and sometimes both are known).

For every row of the master document I would like that the code looks into the other files in folder X for an exact match of either identifier 1 and 2 combined; identifier 1; or identifier 2 in column 1 and 2 and compares the values/text of each column associated with that unique entity (characteristic 1/ characteristic 2 /...). If there is a difference between the master and the secondary excel file I would like that data of the secondary file be added into the cell in the master document (this for every column (characteristic) of that unique entity)

If there is no exact match I would like to copy the whole row of the secondary file beneath the last row of my master document.

When the master document is updated I would like that the secondary file is updated based on the update of the master that just happened. Here, instead of adding data in the different characteristics, I would like to just copy the data from the master in that specific column (characteristic) if there is a difference.

When that is done for the excel secondary 1, I want to do the same for every other secondary file in folder X sequentially.


This is above my capabilities and hope you could help me.

Thanks in advance!

 

[AFPathfinder]

I'm not an expert on databases, but I believe the "master document" should be an Access database and your secondary files could be Excel files that link to the database. Access has too much built-in functionality to maintain data continuity that it would be difficult to recreate it in Excel at that scope.