Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- L.I column: Last Name Column: Name Column:
- A Apple Dan Apple
- A Adams Steve Adams
- B Butler Dale Butler
- C Chalk Shelly Chalk
- E Evans Susan Evans
- G Golden Terry Golden
- for (var i = 2; i<=end; i++){
- var cur = s1.getRange(i,fic);
- var data = cur.getValue();
- var crow = cur.getRow();
- if (data != ref){
- count++
- ref = data;
- if (count != 3){
- var li = data;
- Logger.log("Current row is "+crow+", li is "+li);
- continue;
- }
- else if (count == 3 || i == end2){
- var lr = crow-2
- var cto = ss.insertSheet(first+"-"+li);
- Logger.log("Line 29 lr is "+lr);
- var names = s1.getRange(fr, 6,lr,1);
- Logger.log("Line 31 lr is "+lr);
- var nrows = names.getRowIndex();
- names.copyValuesToRange(cto, 1, 1,1, nrows);
- first = data;
- Logger.log("Line 35 lr is "+lr);
- fr = crow;
- Logger.log("First row of next page is "+fr);
- count = 0;
- continue;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement