The column B has the data in it. I was hoping that I could use the data on sheet2 A5:A15 as the values to filter by. I can input those individually into the code, but thought it might be easier to define the range since it could be dynamic.
Dim cl As Range
For Each cl In Range("B2", Range("B" & Rows.count).End(xlUp))
.Item(cl.Value) = Empty
For Each cl In Sheets("sheet2").Range("A5:A40")
If .exists(cl.Value) Then .Remove cl.Value
Range("B:B").AutoFilter 1, .keys, xlFilterValues
Fluff, you saved me again! I was playing around with that formula, but couldn't quite make it work. The AutoFilter line was the key! I was playing around to see if i could also flip it by changing .Remove to .Show...nope.