Help Needed - VBA Advanced Filter

[oscarpompyang]

Hi, new user here. After scouring the web for help I decided to ask the experts.

I have a database with tagging for each of the entries, and i've set up an advancedfilter macro on it based on user selections. the criteria selection is set up in such a way that users can select multiple options from each of the criteria before they search. the problem is, i belatedly realized that by selecting multiple options, the advancedfilter will show only items tagged to both options in the database. i need it to show the items that are either <option 1> or <option 2>, etc. Is there a way you can suggest for me to go about doing this? I don't want users limited to just one option per criteria per search...

Thanks in advance!

 

[oscarpompyang]

This is the test file that i was playing around with. I have the 6 options laid out in separate rows in the criteria range (don't need the Item column to be part of the search criteria), and gave coding it a shot. Needless to say, i couldn't make it work. I had meant for columns F and J to be a general tag for Genre and Booktype to eliminate blank rows in the criteria range, but if every item is tagged with it, it just shows all items.

 

[RoryA]

Does this do what you want: http://1drv.ms/1vn2JQT ?