title: In Excel, is there a way to link a dropdown menu to specific data?
body: <p>Essentially what I have done so far is create a dropdown menu using the Data Validation tab within the 'Data' tab in Excel. Using a SS I will show what exactly I'm trying to do.</p>
  
  <p>If this can also potentially be done with a vba macro please let me know.</p>
  
  <p>Essentially, when I change the data (where the blue arrow is) I want different data values to appear in the table (in the red circle) for each different item in the dropdown box
  <img src="https://i.stack.imgur.com/Lbllb.jpg" alt=""></p>
  
  <p>Please let me know if this is possible in Excel, thanks in advance for the help!</p>