Thank you so much for this helpfull video. Im learning with every video. Just a question: How to I prevent a line from being moved if the tab indicator is blank. I want it to stay on the first page and not be deleted.
Hey nice video and it actually what i looking for, only maybe because i dont understand of the script coding i dont really know what is happening 😂 but i will try this code later. You are a life saver 👍
Hey Ninja, nice video, though i admittedly didn't understand too much =D do you maybe know how to create a function, that kind of locks cells to each other? i get market data from a GOOGLEFINANCE function, and the data obviously moves every day. i manually enter values in the same row every day, but as the days pass, and the recent prices moves down, i would like my manually entered data to move down as well, though i don't seem to find a way to do this :(
So if you want to copy, not move, all you need to do is delete the row in the code: sheet.deleteRow(row); If you're looking to add more complex conditions for moving rows, check out this video: ruclips.net/video/KekdeXn8P5Y/видео.html
Thanks for making the code available. Writing non-linearly in a linear environment is confusing without the final product at hand. 🤓
Glad it was helpful!
Thank you so much for this helpfull video. Im learning with every video.
Just a question: How to I prevent a line from being moved if the tab indicator is blank. I want it to stay on the first page and not be deleted.
Hey nice video and it actually what i looking for, only maybe because i dont understand of the script coding i dont really know what is happening 😂 but i will try this code later. You are a life saver 👍
Awesome, you're welcome!
Thanks Ninja!! This is very helpful
Glad to hear it!
Hey Ninja, nice video, though i admittedly didn't understand too much =D do you maybe know how to create a function, that kind of locks cells to each other? i get market data from a GOOGLEFINANCE function, and the data obviously moves every day. i manually enter values in the same row every day, but as the days pass, and the recent prices moves down, i would like my manually entered data to move down as well, though i don't seem to find a way to do this :(
I discovered the channel recently and I'm watching the old videos, can you share the code for this video?😃
There is a link to copy the Google Sheet and script in the video description. Thanks for watching!
Hi if I just want copy not moving and specific some rows not all how can I do
So if you want to copy, not move, all you need to do is delete the row in the code:
sheet.deleteRow(row);
If you're looking to add more complex conditions for moving rows, check out this video: ruclips.net/video/KekdeXn8P5Y/видео.html
Lovely thank@@SheetsNinja