title: Bidirectional content syncing between google spreadsheets
body: <p>I am creating a google spreadsheet dashboard to summarize content from many different projects.  All project content is contained in other google spreadsheets.  For each project there is a task list/to-do list.  I am trying to find a solution that will allow me to do the following:</p>
  
  <p><strong>1)</strong> Pull task lists from each project spreadsheet into one master task sheet on the dashboard</p>
  
  <p><strong>2)</strong> Add/edit/delete tasks on the project task sheets, which will then automatically update the master task sheet.</p>
  
  <p><strong>3)</strong> Add/edit/delete tasks on the master task sheet, which will then automatically update the project task sheets.</p>
  
  <p>Numbers 1 and 2 are fairly simple using the importrange() and query() functions but to my knowledge these are only unidirectional solutions.  Any help with number 3?</p>
  
  <p>Sample Documents:</p>
  
  <p><strong><a href="https://docs.google.com/spreadsheet/ccc?key=0AmPYYdOO5yOsdHhPRmxkbGdiN1ZsNzdCUmV3c2VrNnc#gid=0" rel="nofollow">Project 1</a></strong></p>
  
  <p><strong><a href="https://docs.google.com/spreadsheet/ccc?key=0AmPYYdOO5yOsdG1tYXlOY2RoMEVSdXIzS0wxTGtCb3c#gid=0" rel="nofollow">Project 2</a></strong></p>
  
  <p><strong><a href="https://docs.google.com/spreadsheet/ccc?key=0AmPYYdOO5yOsdGw4YVdFb2J0SWpOOF9vZ3hRRHJLdGc#gid=0" rel="nofollow">Dashboard</a></strong></p>