title: Google Apps Script Data Validations and Dropdown
body: <p>I have created a sheet multiple that departments must use.
  (Eg.  Dept 1, Dept 2, Dept 3.)
  All of these departments have their own content with specific items on the second sheet of the spreadsheet.
  (Eg. Dept 1 = A2:F35, Dept 2 = A38:F60, Dept 3 = A63:F89)</p>
  
  <p>A dropdown (Dropdown 1 (<em>cell H60</em>)) is used to select the department.</p>
  
  <p>Once a department is selected I need the data validation of the second dropdown(<em>cell B67</em>) to change in order to display only the selected department's information. I use multiple V-LOOKUP functions</p>
  
  <p><a href="https://i.stack.imgur.com/MYNV8.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/MYNV8.png" alt="Sheet Snippet"></a></p>
  
  <p>I have sat hours trying to create and edit scripts to automatically change the second dropdown data on edit of the first dropdown cell's data, but no luck.</p>
  
  <p>Please let me know if anyone can assist.</p>
  
  <p><a href="https://docs.google.com/spreadsheets/d/1o8TmoHV3jo9SccQnypmTKZUgC_Tkh_uRGHnBtUBg3NA/edit?usp=sharing" rel="nofollow noreferrer">Here is a link to the sheet</a></p>