Advertisement
Guest User

Untitled

a guest
Jul 15th, 2018
68
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.68 KB | None | 0 0
  1. function MoveNames() {
  2. var ss = SpreadsheetApp.getActiveSpreadsheet();
  3. var sh = ss.getSheetByName("Main Trials Schedule");
  4. var opt = ss.getSheetByName("Sheet6");
  5. var headers = sh.getRange(0,0,sh.getLastRow()).getValues();
  6. var last_row = opt.getLastRow();
  7. opt.insertRowAfter(last_row);
  8. var target = opt.getRange("A"+(last_row+1)+":A"+(last_row+2));
  9. var today = new Date().setHours(0,0,0,0);
  10. for(var n=0;n<headers.length;++n){
  11. var date = new Date(headers[n][0]).setHours(0,0,0,0)
  12. Logger.log(today+' N '+date)
  13. if(date==today){
  14. n++;
  15. Logger.log('match on column '+n)
  16. n++;
  17. var trailers = sh.getRange(n,2,2,1);
  18. trailers.copyTo(target);
  19. break;
  20. }
  21. }
  22. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement