Move Rows of Data in Google Sheets - Apps Script Tutorial

In this video, I quickly demonstrate and explain how to put together a Google Sheet and the App Script to be able to quickly move rows of data between tabs using a dropdown status.

[michaelnotarte]

+ 1 like and + 1 subscriber. You made everything look so simple. Well done!

[toflof]

This is exactly what I've been searching for. Thanks so much for sharing your knowledge.

[HJonesT]

This is great, super close to what I was trying to do. Now to brush up so I can make the edits I need, haha.

[gabrielsguerreiro]

Thanks.. i was looking for that solution a long time .. great job👏👏😃😅

[MelissaWaters-xqsj]

So helpful and easy to follow--thanks.

[SJUS-uwbg]

This is exactly what i needed it for, thank god <3

[monikagope]

Thankyou so so so muchh...for the video.

+1 subscriber.
You have our heart🎉❤

[mikedavis]

Hey Ninja, I'm trying to set up multiple charts on the same sheet side by side with their own drop downs. I've figured out how to change the script to grab just the info from the selected chart (For instance if I have 3 charts side by side and I select a drop down for the middle one) however it copies it onto the destination sheet in the first available slots (The left chart instead of staying in the the middle chart). I also can not get just the info from one chart to delete after moving, it still wants to delete the entire row. Please help if you can! Much appreciated thank you!

[DreamShare.Studio]

Thank you, this is very helpful! You have a new subscriber.

One question, if I want to clear the transferred row instead of delete it, what is the proper modification to the code?

[LGT]

Thanks so much for putting this together!! Can you help with what I would need in order to make this work where the row only moves if two conditions are met? I don't want a row to move to a different sheet unless two or three cells have specific values.

[JT-hxhz]

Extremely helpful. What additions to the script would be needed to have formulas in the row be able to mover over as well?

[rabinchaudhary]

Thank you so much for the Awsome & very helpful vdo... Can u plz help me, one more thing when I create google form in the same format and I used this code then it's working or not ???

[jaysonancajas]

Awesome ! Can you make another case. To automatically delete entire row once the one cell has been delete?

[katiehelander]

I've been trying this formula but when I execute it, it deletes both the correct row and the one underneath it. I have the exact script you used pasted into Apps Script, so not sure what the problem is

[gdcwxpw]

Hey,
Thanks for this. I have a sheet that in the status columnin sequence moves through 4 tabs and then it’s finished with. However on tab 3 it would depend on status and another answer on column F drop down.

So if Status = complete and column F was blank it goes to the complete tab.

If column F Said YES it would copy the row to 2x other tabs but also delete from the current tab

[helenchen]

That's an awesome table ... where did you learn about this? I am really interested in it...

[forcenick]

This is awesome, where did you learn to create apps script?

[Troy-iivj]

Thanks a lot for the super helpful video! I do have a question though. Is it possible to move a row from one group to another on the same tab after a box is checked?

[SuperRajan]

Hey Thank you for this amazing tutorial, I am using the Query (importrange) function to acquire data on my sheet, now when i am using this script, it is making a copy of the row instead of moving it. Is there anything that can be done to rectify that?

[beatrizjannmaglanoc]

awesome video! just wondering what if my column b is a hyperlink? would that affect the code?