In each cell in Column F Sheet 1, I have inserted a drop-down list. The drop-down list contains four different terms. In a separate sheet (Sheet 2), I have the four terms from the drop-down list listed in Column A (this is where the information is being taken from). In a third sheet (Sheet 3), I have the four terms written down a second time in Column A. I am trying to make it so that whenever I choose an item from the drop-down list in Sheet 1 Column F, the entire row of information shows up under the corresponding term on Sheet 3. For example, the terms in the drop down list are Accounting, Finance, Tax and Audit. If I select "Accounting" from the drop-down list located in Cell F3 in Sheet 1, I would like for the entirety of Row 3 to show up under the term "Accounting" on Sheet 3.
Solved by V. L. in 22 mins