Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function updateAll()
- {
- var file=SpreadsheetApp.getActive();
- ss=file.getSheetByName("ER");
- var lr=ss.getLastRow();
- var values=ss.getRange(1, 1,lr,13).getValues();
- for (var i=1;i<lr;i++)
- {
- var sn=values[i][1];
- var valuen=values[i][12];
- updateMaster(sn,valuen) ;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement