Hello Everyone,

Please help me find out the solution for this problem.

I have two same excel files having same columns headers.

The master file is also having same columns headers.

File 1 & 2 are updated by two different persons by person 1 & person 2 respectively.

I want the compiler file to be auto updated by the entries of the person 1 & person 2.

I have attached the example files.

Thanks in advance.


Compiler.xlsx
Person 1.xlsx
Person 2.xlsx

Regards,
NeoNirav