Selectively deleting all/each rows in a sheet based on a specific criterion (how?)

1st timer here - I hope the question isn't a waste.

What I’m working with:
I made a report that uses lookup functions to populate it's rows with text descriptions from a XLS database based on a specific initial criterion entered in one cell.
If every row had the description listed this report would be about seven pages long printed. But, no report uses all the potential row descriptions.
I now need to create about 1000 reports…and the idea of deleting the ‘blank’ rows manually seems very daunting, if not prone to error.

The goal:
To ‘automatically’ delete each row that does not fill itself out with row's description according to the logic of the lookup function, i.e., the ‘blank’ (unused) rows.

The question:
Is it possible to define a macro (?) to read whether (for example) the third cell of each row contains a (-) sign and nothing else in the next cell to the right (same row), then to delete the entire row from the workbook?

Any help or suggestions for direction are much appreciated!

I'm sure this must seem painfully obvious to you but is that code for a macro or...? I.e., how would I use it? Thank you!

here is a partial of that report without the underlying formulas (to keep it small). I hope this better illustrates my puzzle. I highlighted the rows that the formulas did not fill when the address was given in the first cell - these are what I'd like to erase by using a ?? macro?

Thank you! works like a charm

Is there a way to specify that the macro (thanks Martin) run on specific rows, thereby avoiding the need to run on the entire (and quite large) worksheet?

Ideally I'd like the code to have, written within it, the ability to act on specific rows.

Any ideas? Thanks!