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