macro.gs

function CleanCountryPage() {
  var spreadsheet = SpreadsheetApp.getActive();
  spreadsheet.getRange('C1').activate();
  spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
  spreadsheet.getRange('E2').activate();
  spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
  spreadsheet.getRange('E5').activate();
  spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
  spreadsheet.getRange('E12').activate();
  spreadsheet.getActiveRangeList().clear({contentsOnly: true, skipFilteredRows: true});
  spreadsheet.getRange('C1').activate();
};

function FillUniversity() {
  var spreadsheet = SpreadsheetApp.getActive();
  spreadsheet.getRange('E2').activate();
  spreadsheet.getCurrentCell().setFormula('=VLOOKUP(C1,TopUniv!A$1:D$200,4,FALSE)');
  spreadsheet.getRange('E5').activate();
  spreadsheet.getCurrentCell().setFormula('=VLOOKUP(C1,TopUniv!A$1:D$200,2,FALSE)');
  spreadsheet.getRange('E12').activate();
  spreadsheet.getActiveRangeList().setValue(new Date());
};