Request for VBA to automatically hide all but one blank row whilst maintaining formatting.

Good Morning/Afternoon/Evening All,

First off I'm very unfamiliar with the VBA coding so basically a rookie.

Bit of a tricky one here, I'm trying to set up a dynamic list within a spreadsheet that will allow users to continue adding data, automatically hiding and unhiding rows as information changes.
The work area is from A13:M318 and contains pre existing conditional formatting to colour the rows based on the data entered.

Is there any way to have the Macro only allow one blank row under the last row of data and unhide/hide the next row down as data is input/deleted. All this whilst still maintaining any blank rows between rows of information half way through the spreadsheet (unless there's a way of shifting information up as a complete row as free rows become available).

I've had little success in finding anything that applies to my criteria and learning the coding specifics is taking time.

Many thanks for any advice in advance.

Tom

Excel Example.jpg

Apologies for the wait, I've been out of the office.

Pretty tricky problem, I don't even know where to start with coding this thing.

Here we are.

Yes the last entry of data is row 19, I just need to be able to extend the list as needed so there always needs to be a fresh blank row at the bottom of the table.

Thanks