in the attached workbook, on the sheets(2), if range("pmt_s") = b6 includes the word "FRT" (at any place), then I want on sheets(2), line 57 to repeat exactly as it is (format, if hidden rows hidden them two) the range ("frt") of the sheets(3)

I know how to write "if sheets(2).range("pmt_s") includes the word "frt" but I don't know how to say the rest...could you help me? Basically the code under sheets(2) should be as follows

Please Login or Register  to view this content.