I have kind of an interesting one. My goal is to be able to select a value from a drop down list and have a table retrieved. here is kind of how my spreadsheet is set up:
[Droplist of herds]
Cows1
Cows2
if you select cows1 then a list comes up of the animals in the closest column. For example animals 1 through 20. On a separate sheet I have a table of all of the animals' health records. I would like this table to pop up when the animals' herd is selected. Any help would be GREATLY appreciated! Thanks!