Hide Recurrence Setting

[cyliyu]

I have a workbook consists of 50 of sheets.
I want to hide the entire row where the column-Recurrence contain a number of "2".
The "Recurrence" is not always in the same "column", in the example attached, Sheet 1- Column "G" and Sheet 2- Column "I".
I also want the code to be "flexible" to allow me to change and set the criteria to "1", "2" or "3" and so on.
Need help, please.

 

[vletm]

cyliyu
Something like this ... press the button?
Note: negative numbers will unhide row

 

[cyliyu]

Thanks. The code in the file work.
Let me try in my workbook when back to the office tomorrow.
Appreciate your help.