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
Bookmarks