VBA Macro needed to delete X amount of rows below the Nth row

Thanks in advance for the help.
I have a set of data with a dynamic number or rows. Could be 10, could be 1000. I want to find the last row of data before any spaces, and delete the next 12 rows. Any help would be great!

I added a sample file of what I'm trying to get accomplished. For the file attached, I want the macro to find the cell after 78627(A:20) and delete the next 12 rows. The rows are dynamic, so the formula needs to be able to recognize the first blank cell whether it happens to be A:5 or A:1000.

Thanks for the help, I know this is a tough one.