|First, please click on the blue line at the end of this post and read the instructions on how to post data in this forum. Then, repost your data so that we can see how it is supposed to line up.|
Second, if you are trying to pull multiple rows and multiple columns from a range based on the entry in a single cell, then I think an Advanced Filter and some VBA code might work for you.
The problem with an Advanced Filter is that you have to manually refresh it each time you change the criteria. In essence, you have to go through the steps to recreate the filter each time.
One way around this is to set up the Advanced Filter once and then use VBA to recreate it each time you change the criteria.
For example, I have a database table in A1:D22, my Criteria Range is G1:G2 and I want to output the filtered data starting in G6. When I change my criteria in G2, I want the filtered data in the table that starts in G6 to update to match the entry in G2.
To accomplish that, I would use a Worksheet_Change macro to recreate the filter whenever I change the value in G2.
With the ranges I described above, my code would look like this:
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$G$2" Then
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.