Advertisement
Guest User

Untitled

a guest
Jun 19th, 2019
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.78 KB | None | 0 0
  1. function moveValuesOnly() { var ss = SpreadsheetApp.getActiveSpreadsheet();
  2. var source = ss.getRange("Sheet2!C1");
  3. source.copyTo(ss.getRange("Sheet1!B1"), {contentsOnly: true});
  4. source.copyTo(ss.getRange("Sheet1!B2"), {contentsOnly: true});
  5. source.copyTo(ss.getRange("Sheet1!B7"), {contentsOnly: true});
  6. source.copyTo(ss.getRange("Sheet1!B8"), {contentsOnly: true});
  7. source.copyTo(ss.getRange("Sheet1!B11"), {contentsOnly: true});
  8. source.copyTo(ss.getRange("Sheet1!B12"), {contentsOnly: true});
  9. source.copyTo(ss.getRange("Sheet1!B13"), {contentsOnly: true});}
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement