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:
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,
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:
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,