title: Run Macro Dropdown List Excel
body: <p>I wrote this Macro out to copy and paste info from a previous sheet to the active sheet. I want to make this into a dropdown list but when using data validation, the macro doesn't run when it is picked. Attached is my code and I am wondering should I make a list box or should I stick with data validation? I know there's a way to make a macro run once clicked in a click box</p>
  
  <pre><code>Sub WorkDay1()
  ActiveSheet.Range("A6:H44").Value = Worksheets("Route Sheet - Manhattan 1").Range("A6:H44").Value
  
  End Sub
  Sub WorkDay2()
  
  ActiveSheet.Range("A6:H44").Value = Worksheets("2").Range("A6:H44").Value
  End Sub
  
  
  Sub WorkDay3()
  ActiveSheet.Range("A6:H44").Value = Worksheets("3").Range("A6:H44").Value
  End Sub
  
  Sub WorkDay4()
  ActiveSheet.Range("A6:H44").Value = Worksheets("4").Range("A6:H44").Value
  End Sub
  </code></pre>