Hide row if certain cells on the row doesn't contain certain value

[user_name]

I've looked around these forums and done some searching on Google but didn't find exactly what i was looking for so i hope you guys can help me out!

Ok, So i have an excel sheet in which i need to do the following:

I have a dropdown menu with some 300 values in cell A1 from which users can select a value. (e.g. "Test" "Test2" "Test3" etc.)

There are 5040 rows in the sheet and the value chosen from the dropdown menu can occur in 6 cells per row. (Columns K to P)

I need a macro that will check these 6 cells per Row for the value chosen from the dropdown menu in A1.

If any of these 6 cells per row doesn't contain the value selected from the dropdown menu in A1 i want to hide the row that doesn't contain that value.

Then i would also like to have a "reset" button in A2 which you can press to unhide the rows again.

I really hope you guys can help me out.

Thanks,
Bas

 

[user_name]

Sorry for the late reply but thank you very much!
I already tried playing with the COUNTIF values but forgot to change the Offset.
Works like a charm now!
Thanks so much for your help.

All the best,
Bas