Google Apps Script: Copy Rows To A New Sheet Based on Cell Value

In this video I show you 3 ways to move or copy a row from one Google Sheet to another Google Sheet based on a cell value in each row.

Method 1 - Copy and Paste
If this is a small, one time task you can always apply a filter to your master sheet and then copy and past the values to other sheets.

Method 2 - Google Query API
The second method is to use Google's Query API to dynamically pull the correct rows into a new sheet based on a cell value. The advantage with this method is that it will continue to capture and copy any new rows added to the master sheet. The downside is that the data on the new sheets are not permanent and will be lost if the master sheet is ever deleted or changed.

Method 3 - Google Apps Script
This is the preferred method if you want to copy the data over in a way that is permanent, but still quick and accurate.

You can review and reuse the script I demonstrate in this video using this Github Gist - https://gist.github.com/palumbo/e4783...

Thanks for watching! And remember to work SMARTER, not HARDER!