Multiple Column Filter

[kcaitch]

I have four columns that are, for example, favorite food 1, fav 2, fav 3, and fav 4. In each of these columns, I want to select from a drop down a type of food. The available types of foods are the same in each column. After I enter the favorite foods of say ten different people, I want to be able to filter all and just see the people that like popcorn, chips, and taffy, regardless of which favorite column it shows up.

My assumption is that this complex filter could not (easily) be achieved through the auto filter or advanced filter tools, so I think it is a VBA or macro solution. I don't have much experience at all in writing this sort of thing, so I thought I would see what everyone on here thinks.

Any ideas?

Thanks,
Ken

Screen Shot.jpg