Create a script for Excel to merge data from 2 files based on the same range of columns

Hi everyone,

I am looking for a freelancer who is able to help me merge data from 2 files in Excel, based on the same range of columns. I would need a script for this.

Here is my problem that I would like to solve:

1. I have a database, when I export the values sometimes values are missing because the server was down for a while. So I’ve decided to export it twice, to minimize the risk of data loss.
2. Now I got two files, which I want to merge together, so in case a cell is empty it will get the data from the other file. If a cell shows empty in file 1 but file 2 shows the data in that cell, file 1 will get the data. In case file 1 allready got data in a cell and file 2 shows the cell empty for that specific cell it should not overwrite as empty, but leave the data of file 1 in the cell.

I must be able to use this script in the future too, in case I got files that got more or less columns it gotta work as well.

I'm using Excel 2013.

Looking forward to hearing from you.

My maximum budget for this task is €30.