Guest User

Untitled

a guest
Jan 17th, 2018
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.38 KB | None | 0 0
  1. function getOrders(){
  2. var ss=SpreadsheetApp.getActive();
  3. var sh=ss.getSheetByName('Orders');
  4. var rg=sh.getDataRange();
  5. var vA=rg.getValues();
  6. for(var i=3;i<vA.length;i++){
  7. var column1Value=vA[i][0];
  8. var column2Value=vA[i][1];
  9. //You can loop through all of the orders data this way and copy the data that you want from each column to the appropriate place on overview
Add Comment
Please, Sign In to add comment