Create drop down using data from different sheet

So I am not sure if this is possible


I want to make a spreadsheet that has multiple drop downs and selections available to the user.


Based on these selections information is populated using a table from another sheet.


In sheet 1 called "Shoulders" I want to be able to select from variety of protocols and have that auto populate the table highlighted in green.


the protocols will all be listed in the protocols" sheet next to it. There will be 10 or so different protocols to choose from.

So using these as examples is it even possible in this format?


Biggest questions I need answered are


  1. Can I create a drop down menu on "shoulders" that refers to information on the "protocols" page.
  2. Then when selecting my desired protocol can I get it to auto populate a table.


Apologises if this was poorly explained

Posted on Mar 18, 2023 7:03 PM

Reply
1 reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Create drop down using data from different sheet

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.