Advanced Filter problems - returning more than expected

[LeahWright]

Have two three tabs in a workbook.
Tab 1 - Used to display results of Advanced Filter

Tab 2 - Contains Criteria Range for Advanced Filter (90 rows + header row)

​

Tab 3 - Contains List Range for Advanced Filter (5450 rows + header row)

​

I want to find all rows in Tab 3 that contain the same Case IDs that appear on Tab 2 in column B and copy columns A:K to Tab 1. Some Case IDs appear once and some may appear 20 times. I want all instances to copy.

I set Advanced Filter up as such:

The problem is, all 5450 rows from Tab 3 are being copied to the results tab, instead of only the rows that contain a value that appears on Tab 2. Am I missing a step?
​

 

[LeahWright]

Anyone? I need this to complete a task at work this morning.

 

[Peter Thompson]

I think that its because the header name in the criteria is different from the header in the data so the advanced filter has nothing to filter on.

 

[LeahWright]

I changed the header row so the column headings are identical and I am still getting the same surplus results.

 

[RoryA]

You have specified entire columns for your criteria range. If you have blank rows in the criteria range you will get all records back, so you need to adjust that.

 

[LeahWright]

rorya, That was the key! Thank you.