Complete data of a master table without overwriting given data

[KaiA]

Hi all,

Finally, I found out how to attach a file!

Please note:

• all tables are identical
• when I start the macro I would like that it checks the data in the sheet "Table1" to the left or to the right (does not matter) an copy the data to the master sheet without overwriting any given data in the master sheet
• some of the cells in the master sheet contain values already, these values should not be overwritten
• the target is to retrieve data for every empty cell in the master sheet
• the table in the sheet "Table1" next to the master sheet will contain formulas which retrieve data from different sources
• so once the "Table1" sheet retrieved data from one source, this data should be copied (just the data, not the formulas) to the master when I activate the macro, but without overwriting the existing data
• then I will change the formulas in "Table1" so that new data is retrieved from a new data source
• then I will hit the macro button again, in order to copy the new data to the master again, but only filling in the data there is the corresponding cell is empty

I hope that this is clearer.

Many thanks for your effort!

Best,
Kai