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 edit the destination, it breaks the formula. Here, I present a method  to create 2-way sync with an onEdit() script.