[GAS]セルの値をコピー
function copy_values() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheet = ss.getActiveSheet(); var get_range; var set_range; for(var i = 4 ; i < 30 ; i+=2){ get_range = sheet.getRange("J"+i+":K"+i); set_range = sheet.getRange("J"+(i+1)+":K"+(i+1)); set_range.setValues(get_range.getValues()); } }