title: Dynamic Depending Lists in Separated WorkSheets in VBA (2)
body: <p>I'm working with 7 dynamic dependent lists, and I thought the best way to automate the process and avoid to arrange anything in a future if I modify the lists was a VBA code.</p>
  
  <p>The VBA code that I started to work on it is posted on: <a href="https://stackoverflow.com/questions/10586616/dynamic-depending-lists-in-separated-worksheets-in-vba">Dynamic Depending Lists in Separated WorkSheets in VBA</a></p>
  
  <p>That code is just for the 2 first lists.</p>
  
  <p>That's the main table that I have. I want pick lists for the first row only for the yellow columns:</p>
  
  <p><img src="https://i.stack.imgur.com/96Des.png" alt="enter image description here"></p>
  
  <p>That's the table that I have the lists (they must be dynamic):</p>
  
  <p><img src="https://i.stack.imgur.com/C5dGY.png" alt="enter image description here"></p>
  
  <p>The relations between my lists are:</p>
  
  <ul>
  <li>Responsible list and Site list are related with Project list.</li>
  <li>The other lists are related with the site list.</li>
  </ul>