How to auto populate a table on another sheet/tab based off of a drop down.

[Boulder127]

The issue I am dealing with is that I am trying to auto populate cells in a table on a secondary sheet/tab based off of the main tab with specific sections, when I click the drop downs I want it to auto fill in that table for the specific rows/columns.

The attached pictures are all that I can provide. On "Capture1" which is my main table where I enter all the information and "Capture2" is where I want those names to auto fill when I choose the drop down list next to the names on "Capture1".

 

[severynm]

I have no idea what your data looks like, but Filter is likely a good starting point.