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