Transfer cells range to another sheet if first cell of destination range is empty

[kopapa]

Hi to all!
I've got a project which is quite complex (at least for me). So, I'm taking it one step at a time

The first step is creating a macro evoked by a push button (which is already in place) which will achieve the following:

Sheet1 is the source worksheet
Sheet2 is the destination sheet

With the push of the macro button (present in Sheet1) I want to calculate formulas in specific cells (B4, C4, B6, L61) AND copy the cells' values to specific cells in Sheet2 (M10, N10, O10, S10) BUT only if the FIRST cell of this range (i.e. M10) is empty.

If it contains data then paste the values to the cells below (M11, N11, O11, S11) etc etc. The "check for empty cell" routine is necessary because the macro will be evoked continuously (push the button on Sheet1 - Calculate - Transfer to empty cells on Sheet2 - Loop)

Any help will be greatly appreciated!
Thanks!

 

[VoG]

Cross posted Transfer cells range to another sheet if first cell of destination range is empty