I'm not very familiar with Google Script.
I have this script that copy the data from a cell to another cell. However, if the cell is empty i need the destination cell will remain its value and not take the empty value of the source.
E16 - the source cell
C16 - the destination cell
var s = SpreadsheetApp.getActiveSheet();
r = s.getRange("E16")
// copyValuesToRange method will copy value in E16 to C16(range of C16 - 3,3,16,16)
r.copyValuesToRange(s,3,3,16,16);
Hope you can help me on this.
Thank you
Bookmarks