Hi all,
I try to achieve the following:
- I have one master table in a worksheet
- And an identical table in another worksheet
- If a cell in the master sheet table is empty, the code should check the corresponding cell in the other worksheet table
- If the corresponding cell contains a value, this value should be copied to the empty cell of the master sheet table
- This should be repeated for all cells in the master sheet table
- It is important that given values in the master sheet are not being overwritten.
- Is it possible to set the active sheet as the sheet that contains the master table and to always copy the data from the worksheet tab next to it (to the left or right, does not matter). I would like to avoid to always update worksheet names in the VBA code.
Many thanks,
Kai