title: Multiple Worksheet Change Events: Multiple Dropdowns
body: <p>I am trying to create a workbook where if I change a dropdown on 1 sheet, it automatically updates that same dropdown on a second sheet. These dropdowns will represent different scenarios and my purpose in creating this is to allow the end-user the ability to change the scenario dropdown from any sheet, rather than just one.</p>
  
  <p>I used this reference to create a VBA for changing 1 dropdown -<a href="https://answers.microsoft.com/en-us/office/forum/office_2010-excel/use-two-drop-down-menus-to-control-each-other/21354e76-c8ab-4116-aff7-1916cd44b532" rel="nofollow noreferrer">Original VBA code referenced</a> - and it worked correctly (<a href="https://1drv.ms/x/s!AmcGUE_vrclQ7TJf86wLLGH833FZ" rel="nofollow noreferrer">See example workbook to download</a>). However, now I want to add the other 2 dropdowns so that if any changes are made to them it updates accordingly.</p>
  
  <p>I'm also open to other solutions if you know of something better.</p>