Advertisement
Guest User

Untitled

a guest
Aug 20th, 2019
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.13 KB | None | 0 0
  1. L.I column: Last Name Column: Name Column:
  2. A Apple Dan Apple
  3. A Adams Steve Adams
  4. B Butler Dale Butler
  5. C Chalk Shelly Chalk
  6. E Evans Susan Evans
  7. G Golden Terry Golden
  8.  
  9. for (var i = 2; i<=end; i++){
  10. var cur = s1.getRange(i,fic);
  11. var data = cur.getValue();
  12. var crow = cur.getRow();
  13. if (data != ref){
  14. count++
  15. ref = data;
  16. if (count != 3){
  17. var li = data;
  18. Logger.log("Current row is "+crow+", li is "+li);
  19. continue;
  20. }
  21. else if (count == 3 || i == end2){
  22. var lr = crow-2
  23. var cto = ss.insertSheet(first+"-"+li);
  24. Logger.log("Line 29 lr is "+lr);
  25. var names = s1.getRange(fr, 6,lr,1);
  26. Logger.log("Line 31 lr is "+lr);
  27. var nrows = names.getRowIndex();
  28. names.copyValuesToRange(cto, 1, 1,1, nrows);
  29. first = data;
  30. Logger.log("Line 35 lr is "+lr);
  31. fr = crow;
  32. Logger.log("First row of next page is "+fr);
  33. count = 0;
  34. continue;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement