Merhaba altaki gibi Google Sheets de yaptigim bir makro var sadece her yeni satir eklendiginde belirtilen satirlarin alta kopyalanmasini nasil yapabilirim
k l m n o satirlarindaki hucreler her yeni satir eklenince alta da kopyalanmasini nasil saglayabilirim simdidien tesekkurler
k l m n o satirlarindaki hucreler her yeni satir eklenince alta da kopyalanmasini nasil saglayabilirim simdidien tesekkurler
CSS:
function yeni() {
var spreadsheet = SpreadsheetApp.getActive();
spreadsheet.getRange('K4').activate();
spreadsheet.getRange('K3').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_NORMAL, false);
spreadsheet.getRange('L4').activate();
spreadsheet.getRange('L3').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_NORMAL, false);
spreadsheet.getRange('M4').activate();
spreadsheet.getRange('M3').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_NORMAL, false);
spreadsheet.getRange('N4').activate();
spreadsheet.getRange('N3').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_NORMAL, false);
spreadsheet.getRange('O4').activate();
spreadsheet.getRange('O3').copyTo(spreadsheet.getActiveRange(), SpreadsheetApp.CopyPasteType.PASTE_NORMAL, false);
};