VBA to Import Data from Table Based on Cell value

[notaguru1]

Hi,

I have 2 sheets, one with a table full of data and another with just some static data fields. I'd like to import data from sheet "All Table" into a brand new sheet called "Txn 2" based on cell D7 in sheet "Static Data".

The Identifier in cell D7 in the "Static Data" sheet will match the identifier field in column B of the "All Table" sheet. So when there's a value match I'd like to bring in all rows that have that ID in column B. If not matches are found I'd like a prompt to come up that days "No Transactions Found"

I'll assign a button to this macro so it can done be on demand.

Thanks for your help