Data range starts from A9:M9, and last row varies on day to day basis.

Adjacent cells like A1:M8, have data, which should not get disturbed.

Column B has identifier flag, which in case is not there, entire row should be removed.

So, Macro should
1) search from A9:M9 till last available row (Range), and
2) see, if row cell in Column B has either of the word 'XX' or 'YY', then it should leave entire row as it is and (row be retained)
3) Else, If row Cell in Column B has word, other than 'XX' OR 'YY' macro should delete entire row is moved (shift) up, (ensure Range A1:M8) remains untouched.

How to do this?

Thanks