Help creating a macro to identify and delete specific rows.

Hello, I have a spreadsheet that I would like to add a macro to to identify that if in column H there is an output that reads COF01, to find the obligation number in coulmn B in the same row. Then identify all other rows of data that have the same obligation number and delete them. I have attached a small example of the s/s, so the goal is that all rows that are highlighted purple would automatically be deleted out. If anyone could provide a marco or suggestions of how to creat one I would really appriciate it. Thank you!Example.xlsx

Thanks for the reply, the white block of 0449 would not be deleted because it contains different obligation numbers in column B. I need the macro to identify the ids in column B and then delete all the rows that have the same id in column B.

Thank you that worked great! let me know if you update it to deleting the rows.