Hello I'm still not able to get this to work. I trying to use VBA advanced filter. I have everything filtering and working just fine except the column with "numbers" which isn't filtering. I'm thinking is based on the criteria I've set or the name manger input I gave. For the criteria, this is what I've got for the number column: =IF(K6="","*",K6) Not sure if the wildcard * works for numbers as well or just text. The idea is I have a column with only numbers and I've created a name rang to filter based on what number I select. For the name range, this is what I've got for input: =OFFSET(Lists!$O$5,,,COUNTA(Lists!$O$5:$O$110))
Solved by G. H. in 21 mins