Filter a Table based on contents in a different cell

[MoreGone]

I am using excel to create an email message with a lot of data points from an excel table. I've got a 2nd table of info that I want to append at the end. The data in the email message is based off the Branch ID, when I use the drop down to change the Branch ID, the form updates. I would like my 2nd table to be filtered when the Branch ID is updated.

What I have done is use the Branch ID to be a search field. I then use conditional formatting to Search my table for the Branch ID and fill the background color. I then filter the table based off the fill color. The search does work, but each time I change Branch ID, I have to re-filter the table.

Any ways to better approach this?

 

[MoreGone]

I found my solution here - https://www.excel-easy.com/examples/advanced-filter.html