i have code
function archivedata() { var sss = spreadsheetapp.openbyid('1tdfubunw...'); // sss = spreadsheet var source = sss.getrange('code!d5:f78'); // source = source sheet //copy target var cnumber = sss.getsheetbyname("code").getrange('f3').getvalue; // column number source.copyto(sss.getsheetbyname("s-28").getrange(5,cnumber), {contentsonly: true}); } error: keeps returning error in last line of code. works when put number instead of using class cnumber.
in cell 'code!f3' specify target column number. variable specified month user selected. example, september cnumber class returns: 3, october it's 7, november 11, december 15, january 19, february 23, march 27, , on ... way august.
so, goal tell script paste copied values. however, column needs paste varies on selected month.
this line code strange:
var rownumber = shcl.getrange('code!f3').getvalues. try using getvalue() instead.
and code incorrect:
tss.getrange('s-28!'&rownumber) change tss.getrange('s-28!' + rownumber)
