I have a range of data in sheet 1 that I want to filter by column one. Column one contains cells like "BCX" and "DUV". I want to filter out rows that in column 1, start with the letters: B, X, N, C, V, M, L, H, and D. I then want to copy the remaining values to a new sheet.

I have seen somewhere that you can only have three criteria when auto filtering, in that case I may have to filter three times.

I know how to filter out one but I can't filter out more than one.

If anyone can help me with this dilemma that would be great.

Thanks