Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function MoveNames() {
- var ss = SpreadsheetApp.getActiveSpreadsheet();
- var sh = ss.getSheetByName("Main Trials Schedule");
- var opt = ss.getSheetByName("Sheet6");
- var headers = sh.getRange(0,0,sh.getLastRow()).getValues();
- var last_row = opt.getLastRow();
- opt.insertRowAfter(last_row);
- var target = opt.getRange("A"+(last_row+1)+":A"+(last_row+2));
- var today = new Date().setHours(0,0,0,0);
- for(var n=0;n<headers.length;++n){
- var date = new Date(headers[n][0]).setHours(0,0,0,0)
- Logger.log(today+' N '+date)
- if(date==today){
- n++;
- Logger.log('match on column '+n)
- n++;
- var trailers = sh.getRange(n,2,2,1);
- trailers.copyTo(target);
- break;
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement