Deleting tables with macros

Bo - Sep 8, 2015 at 11:56 AM

I've got a long dataset.

At some point in the sheet there are tales that start with a row with a text in the first cell "Please specify" and last row of the table with a text in first cell "Valid".

I need to delete such tables, they are 5 rows in length every time.

Can anyone suggest how to do with macros?

Or maybe there is any other way?