質問編集履歴
2
あ
test
CHANGED
|
@@ -1 +1 @@
|
|
|
1
|
-
Google A
|
|
1
|
+
Google Apps Script 最終行までデータを拾って、別のシートの最終行から一個したの行に貼り付ける
|
test
CHANGED
|
File without changes
|
1
修正
test
CHANGED
|
File without changes
|
test
CHANGED
|
@@ -36,15 +36,15 @@
|
|
|
36
36
|
|
|
37
37
|
var ss = SpreadsheetApp.getActiveSpreadsheet();
|
|
38
38
|
|
|
39
|
-
var sheet_copyFrom = ss.getSheetByName('Sheet
|
|
39
|
+
var sheet_copyFrom = ss.getSheetByName('SheetA');
|
|
40
40
|
|
|
41
41
|
// コピー範囲取得
|
|
42
42
|
|
|
43
|
-
var copyRange = sheet_copyFrom.getRange("A2:
|
|
43
|
+
var copyRange = sheet_copyFrom.getRange("A2:C100");
|
|
44
44
|
|
|
45
45
|
//Paste 範囲
|
|
46
46
|
|
|
47
|
-
var sheet_copyTo = ss.getSheetByName('Sheet
|
|
47
|
+
var sheet_copyTo = ss.getSheetByName('SheetB');
|
|
48
48
|
|
|
49
49
|
var copyValues = copyRange.getValues();
|
|
50
50
|
|