I am trying to loop through the whole row in my google sheet and copy some of the data from one sheet to another. The list will get longer over time.
More specifically: If input in column B equals "blue", than copy the values from column A and C into another sheet. Do this for all columns till the end of the column.
Link to my spreadsheet: https://docs.google.com/spreadsheets/d/1xnLygpuJnpDfnF6LdR41gN74gWy8mxhVnQJ7i3hv1NA/edit?usp=sharing
- The loop stops when the colour does not equal blue. Why?
- As you can see I used a for loop. Is that even the way to go?
- Can I do anything about the speed of the code execution?
Any comments, hints or help are highly appreciated.
Regards!
See Question&Answers more detail:os