Delete contents below a search using VBA in Excel

I am trying to use a macro to delete data that follows after a certain word/phrase in excel.

The problem is the cell position can vary depending on how many lines there are in the spreadsheet after the report has been run/exported. I need a solution, if possible, to target a certain phrase (using the find function i presume) and delete 30 cells down from that wherever the text may be (no cet cell).

Is this possible?

Toby