Automatically unhide rows based on a value that is changed by a formula

Good afternoon all,
I've got a setup of 30 rows that are hidden, and unhide as the previous row receives data (So A2-30 are hidden automatically, and if A1 has value, A2 is unhidden, if A2 gets a value, A3 is unhidden, etc).

The way I'm currently trying to do this is if a cell in a row has a value, it returns a 1 to column J, and I then have an overall cell return the sum of all the rows (So if J1 is my sum cell, it will = the sum of J2-J30). With that value in J1, im using the below code to unhide the correct rows (the row number's dont match).

Please Login or Register  to view this content.

This code works perfectly if I manually change my overall J cell to 1-4, but it doesn't work if my function in my overall J cell changes it.

To simplify, if I manually type 2 into J4405, it runs my VBA correctly; if my function in J4405 (which is the sum of J4406-J4409) changes the value to 2, it doesn't automatically update.

Unfortunately, I don't believe filtering is what I'm looking for.
My ultimate purpose is to have 30 rows that have a special format, and all of them but the first starts out as hidden, and once the top row receives data, the second becomes unhidden, this way only rows with value + an extra bottom one are visible.