title: Use a Google Forms to update existing Google Sheets
body: <p>I'm trying to build a Google Forms that fills out certain cells of an existing Google Sheets with the responses from the Google Forms. I also need some of the answers on the Google Forms to come from the spreadsheet in a drop down style menu.</p>
  
  <p>The existing spreadsheet is currently being used by an organization to have its members log some information on a weekly basis, however, some members continue to fill out the form incorrectly no matter how many times I've corrected them. For this reason I'm trying to make the process more automated.</p>
  
  <p>The way the current spreadsheet is set up is that there are multiple sheets for different divisions of the organization. In each sheet there is a column dedicated to the names in that division, with a different name on each row of that column. There are also columns dedicated to specific weeks, so week 1 information is say put into Column D and E, Week 2 information in F and G, etc. </p>
  
  <p>EX: </p>
  
  <p>#  | Name  | Percent  |... Week 1  ....       |... Week 2 ....   | ....</p>
  
  <p>1   |.. Bob..| 0%..... ..| Info 1| Info 2 | Info 1| Info2..|</p>
  
  <p>2   | ..Joe..| 99%......| Info1..................................</p>
  
  <p>I'd like to be able to:</p>
  
  <ol>
  <li>Make the first question of the form a drop down menu selecting the division, which would then make the rest of the questions' information based off the sheet corresponding to that division.</li>
  <li>Second question a drop down menu to select the name. The names would be based off the names listed in the already existing name column of the spreadsheet.</li>
  <li>A drop down menu to select the specific week they are submitting information for.</li>
  <li>A fill in box question that they fill in with "Info 1".</li>
  <li>A fill in box question that they fill in with "Info 2".</li>
  </ol>
  
  <p>When submitted the form would find the correct sheet based off (1), then find the correct row based off (2), then find the correct column based off (3), then copy (4) and (5) into the corresponding cells.</p>
  
  <p>Is it possible to do this? Or would I need to create a separate form for each division?</p>
  
  <p>I don't have any familiarity with Google scripting, although I am experienced with C++ and have a basic working knowledge of scripting in Python.</p>