Move Row Between Sections Automatically in Google Sheets - Google Apps Script Tutorial [SheetsNinja]

Ever needed to move a row of data to a different section on the same tab automatically? Look no further than this simple tutorial!
Make a copy of this Google Sheet to try for yourself: bit.ly/3zaRM2Q

[@PatrickWalsh-y8b]

Is there a way to have one selection move in the same sheet and another move to a separate tab?

[@BraveHeart-ht8zf]

nice share..thanks

[@SheetsNinja]

Thank you! Cheers!

[@SindyKrinke]

Hello, I found this video and it helps me a lot. But I have a question about it. If I want to keep the data of the first column (where you can set prospects or leads etc.) and not delete it, how should I change the code to do that? It is possible to keep this data without problems? Thank you

[@SheetsNinja]

All you have to do is remove the line in the code that goes like this:
data[0][0] = '';

[@LizzieLoomis-q8c]

Is there a way to keep hyperlinked text active when you move it from one section to another?

[@SheetsNinja]

Yes, you have to do .getRichTextValues() and .setRichTextValues() to copy hyperlinked text. It can be a little more complicated to layer that in with the .getValues() and .setValues(), which is why I didn't cover it in this video.

[@Drag0nStorm1]

innnnnnsane

[@SheetsNinja]

Awesome, hope this was helpful for you!

[@VictorRomero-se6rk]

Could you do one exactly like that but for checkboxes

[@SheetsNinja]

So are you talking about having multiple columns for check boxes for different sections, or would you just have two sections and have the checkbox move it to the 2nd section?

[@VictorRomero-se6rk]

@@SheetsNinja Yes so it would be moving one row to a different section on the same sheet once selecting the checkbox, the move would only be a couple of rows below origin