title: Automatically update cells with dependent dropdown values
body: <p>I have a sheet where there are two columns (Column C and column E). Column E has cells with dropdown menus that are dependent on the value of the cells in the same row, Column C.</p>
  <p>I am trying to get the value in Column E to automatically change to the first option of the new corresponding dropdown menu when the value in Column C changes. As it stands, when the value in Column C changes, the value from before in the respective Column E cell remains, and I have to manually click and select from the new list.</p>
  <p>Here is what I have to start:</p>
  <pre><code>Private Sub Worksheet_Change(ByVal Target As Range)
  Dim rng(1) As Range, rng1 As Range
  Set rng(0) = Range(&quot;C71:C91&quot;)
  Set rng(1) = Range(&quot;E71:E91&quot;)
  Application.EnableEvents = False
  If Not Intersect(Target, rng(0)) Is Nothing Then
     For Each rng1 In rng(1)
       i = i + 1
       rng1 = Range(&quot;&quot; &amp; rng(0).Value2)(i, 1)
     Next
  End If
  Application.EnableEvents = True
  End Sub
  </code></pre>