Dynamic conditional hide/unhide rows in particular ranges

[Jules99]

Hi folks,

Have been struggling fruitlessly with code copied from similar examples for a couple of days, but no luck.
My worksheet has 50 boxes (ranges). See screenshot below (I couldn't see a way to upload the file, sorry).
Basically, i want unused rows in each range to be hidden until my user inputs data in the row above.
The text alongside explains each box explains the action required.

Any help gratefully received as I'm not versed in VBA.

Many thanks.


-- removed inline image ---

 

[Jules99]

Oh... not sure what happened above. Moderator, feel free to delete my first post.

Will try and explain.
My worksheet has 50 data boxes 9 rows x 4 columns, each separated by one row, making a spacing of 10 rows.
The first row in each range is pre-seeded with data.
At start of day, each range shows the first row (pre-seeded) and the second row (empty) only, the other 7 rows in each range being hidden.
The third row in each range stays hidden until the user puts data in Col D. Then the next free row (4th) unhides, and so on.

Any range can have data input into the second (or subsequent rows) Col D, as each row unhides.
Each range can have a different amount of data (rows hidden or unhidden).

I've struggled fruitlessly with VBA from similar examples.
Help gratefully received. Thanks.