回答編集履歴
1
あ
answer
CHANGED
@@ -8,7 +8,7 @@
|
|
8
8
|
const sheet = e.range.getSheet();
|
9
9
|
if(sheet.getName() !== srcSheetName) return;
|
10
10
|
const r = e.range.getRow();
|
11
|
-
const row = ["","",""
|
11
|
+
const row = ["","",""].concat(sheet.getRange(r, 4, 1, 5).getValues()[0]); // D 列から I 列 ?
|
12
12
|
sheet.getParent().getSheetByName(dstSheetName).appendRow(row);
|
13
13
|
}
|
14
14
|
```
|