function CopyC1() {
  var ss = SpreadsheetApp.getActive();
  ss.getRange('MODTANEWBIE_DATA_2!C1').copyTo(ss.getRange('MODTANEWBIE_DATA_2!C6'), SpreadsheetApp.CopyPasteType.PASTE_FORMULA, true);
}


function test(){
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("MODTANEWBIE_DATA_2");

  var source = sheet.getRange('C1');

  var sourceFormulas = source.getFormulasR1C1();


  var target = sheet.getRange('C6');
  target.setFormulasR1C1(sourceFormulas);
}