Ok, here is my problem. I have a very large database and I need to filter by one specific code(214). The problem is, the code cells can have up to 80 different codes at once. It's not very handy to do 'text to columns' to split these up into 80 different columns, and the code isn't necessarily in the same place in the order of codes. For instance one cell may show: 214, 101, 95, 25 and another cell may show 217, 214, 35, 2

I don't know if there is an easy way to do this with filter and sorting, or a VBA that would work....any ideas? Thanks!