Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function moveValuesOnly() { var ss = SpreadsheetApp.getActiveSpreadsheet();
- var source = ss.getRange("Sheet2!C1");
- source.copyTo(ss.getRange("Sheet1!B1"), {contentsOnly: true});
- source.copyTo(ss.getRange("Sheet1!B2"), {contentsOnly: true});
- source.copyTo(ss.getRange("Sheet1!B7"), {contentsOnly: true});
- source.copyTo(ss.getRange("Sheet1!B8"), {contentsOnly: true});
- source.copyTo(ss.getRange("Sheet1!B11"), {contentsOnly: true});
- source.copyTo(ss.getRange("Sheet1!B12"), {contentsOnly: true});
- source.copyTo(ss.getRange("Sheet1!B13"), {contentsOnly: true});}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement