Here are 3 video tutorials for moving an entire row of data based on some trigger. The first 2 use checkboxes, the last uses a dropdown menu. Move Entire Row with Checkbox Move Entire Row with Checkbox 2-way Move Entire Row with Dropdown

As a follow-up to my previous video showing how to setup 2-way data sync  in a workbook, this shows how to setup data sync across different workbooks.  The most important difference is that this setup uses an installable trigger rather than a simple trigger, and read more

This is a video tutorial for one of my most-requested setups: 2-way data sync.  FILTER(), QUERY(), IMPORTRANGE(), and other methods can pull data from one tab or range to another, but they are all 1-way: source to destination. When you want to be able to read more