109u109 - 経済統計練習帳

function myFunction() {
 
 
    var id="15wm5tn9zyrvR4oO8135EunRjFnkwoQ6ix7uc79lqavU";
 
 
 var ex1 = SpreadsheetApp.openById(id);
  var sheet = ex1.getSheetByName("data");
 
    var range = sheet.getRange("A1:I").getValues();
 
 
   shx = ex1.getSheetByName("io");
 
  for(s=1;s<100;s++){
  shx.getRange(s,2).setValue(range[s-1][6]);
}
 
 
}