Deleting Rows using data from other workbook/sheet

Thanks in advance for the help, as this is my first question:

I would like to delete all rows in "Workbook A" that contain the phrase
"Active Coverage" in "Workbook B". All rows have a Unique ID column that is shared between the two workbooks (long 12 digit numbers).

Essentially; I have one 10000+ row file (Workbook A), and when Active Coverage is identified in another workbook (Workbook B), I have to manually delete those lines showing "Active Coverage" from WorkBook A
(can be 1000's of lines).

If someone could help, or point me in the right direction, you would save me 100's of manual labor hours.

Thanks so much. Let me know if I need to clarify anything, as this is my first question.

Hi

Do you want to delete the rows from workbook A based on the phrase Active Coverage somewhere in a specific column, or when the phrase is selected in workbook B, it brings back a list of IDs and you use the IDs to delete from workbook A?

rylo