When you simply Duplicate or Copy a sheet, the protections don’t come with it. Here’s how to copy a sheet while preserving protections.
Another 3 videos for you this time! Lock Cell After Edit Lock Entire Row After Edit Lock Row with Installable Trigger
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