How to hide rows based on whether cell in previous row is blank

I have a worksheet that I use to record client information. On this sheet are several tables that I use to store data in. Currently each table is 10 rows high. What I would like to do is hide all emptry rows except the row below the last row with data. So for example, I store data in cells B37:J37 and I would like row 38 to show, but rows 39-45 to remain hidden.

Is there a way of doing this in VBA? I've posted a sample of my spreadsheet in case anyone cares to take a look.

Thank you.

There is a way to do this in VBA that I know, but it would be based off of a "case" or some value input where the rows can be hidden or not.

so, for example

Please Login or Register  to view this content.