Advertisement
Guest User

Untitled

a guest
Sep 10th, 2019
56
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.31 KB | None | 0 0
  1. function updateAll()
  2. {
  3. var file=SpreadsheetApp.getActive();
  4. ss=file.getSheetByName("ER");
  5. var lr=ss.getLastRow();
  6. var values=ss.getRange(1, 1,lr,13).getValues();
  7. for (var i=1;i<lr;i++)
  8. {
  9. var sn=values[i][1];
  10. var valuen=values[i][12];
  11.  
  12. updateMaster(sn,valuen) ;
  13.  
  14.  
  15. }
  16. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement