Hello all,
i hope i can get a little help from you for the following issue.
I want to program a google spreadsheet script and want to do the following:
function ifAbfrage1(){
var ss=SpreadsheetApp.getActiveSpreadsheet();
var Date="K7";
var requestCell="C1";
var Today=ss.getRange(Date) .getValue();
var ValueOfCell = ss.getRange(requestCell).getValue();
if(ValueOfCell==Today){
ss.getRange("A1").moveTo(SpreadsheetApp.getActive( ).getSheetByName("MovedSheet").getRange("A1"))
ss.getRange("B1").moveTo(SpreadsheetApp.getActive( ).getSheetByName("MovedSheet").getRange("B1"))
ss.getRange("C1").moveTo(SpreadsheetApp.getActive( ).getSheetByName("MovedSheet").getRange("C1"))
}
}
My plan:
I want to move cells from my current Sheet to the Sheet "MovedSheet".
I created variable ss for the current sheet.
I set a special Date in cell K7
The programm should check now all cells in column C if there is a match to the setted value in K7.
If there is a match, it should copy the whole row to "MovedSheet".
Till now he is just checking the first row (1) but i don't know how to do it recursive that he will check all rows till for example 1000.
Best regards,