How do I use check boxes to allow multiple search criteria?

[GTengineer]

Hello Everyone.
This is my first post so I am not sure how everything works or if my title is correct, please let me know if anything needs changing. Anyway to my problem, I have a database on my second sheet and on the first sheet there is a selection of the important headings from the database.

E.g
sheet 1
A B
9 Report Failure Search Button CheckBox (linked to F9)

10 Author PEH Search Button CheckBox (linked to F10)

11 Search Button

B9 Failure is selected from a drop down menu, if I click the search button then it will search the database for all failure reports. This works fine and will give you a list on sheet 3. This also works if I press the search button for the Author.

My problem is I want to click the search button on row 11 and would like it search for both report and author when they are checked, there are more rows and search buttons which I have not shown. So when I would like it to search for which ever checkBoxes are checked. This is the code I have used, apologies it is a bit messy I am by no means an expert. This shows how it searches for a single variable. If you could please explain how I could make this search for the checked boxes I would be very grateful.

Please Login or Register  to view this content.

Again I would be greatful for any help.

[npamcpp]

Hi, you should wrap your code in code tags like this
[code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code]

Apart from that, it will be much easier to work on your issue if you can post a sample file with a few rows of dummy data.

[GTengineer]

Thanks, I have made the code ajustment. I will make up a dummy file and attach it as well.

[GTengineer]

As promised here is the test file, please feel free to change it as you wish. This problem really has me stumped!

Test.xls