- Katılım
- 28 Kasım 2006
- Mesajlar
- 249
- Excel Vers. ve Dili
- 2007
- Altın Üyelik Bitiş Tarihi
- 26-05-2023
Merhaba altaki gibi Google Sheets de yaptigim bor makro var sadece her yeni ssatir eklendiginde belirtilen satirlarin alta kopyallanmasini nasil yapabilirim
k l m n o satirlarindaki hucreler her yeni satir eklenince alta da kopyalanmasini nasil saglayabilirim simdidien tesekkurler
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);
};
k l m n o satirlarindaki hucreler her yeni satir eklenince alta da kopyalanmasini nasil saglayabilirim simdidien tesekkurler
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);
};