Guest User

Untitled

a guest
Jul 17th, 2018
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. function refreshRefNums(sheetName,refColumnIndex,refFirstRowIndex){
  2. var spreadSheet = SpreadsheetApp.getActive();
  3. var sheet = spreadSheet.getSheetByName(sheetName);
  4. var refLastRowIndex = sheet.getLastRow();
  5. var baseRange = sheet.getRange(refFirstRowIndex,refColumnIndex,2);
  6. var destinationRange = sheet.getRange(refFirstRowIndex,refColumnIndex,refLastRowIndex);
  7. baseRange.autoFill(destinationRange, SpreadsheetApp.AutoFillSeries.DEFAULT_SERIES);
  8. }
  9.  
  10. function refreshRefNumsIOUData(){
  11. refreshRefNums("IOU Data",1,2);
  12. }
Add Comment
Please, Sign In to add comment