automatically hide/ unhide a row based on information in a cell from row above? How?

OK,

you guys were great in helping me with my IF/VLOOKUP functions, now I have something new! I have several empty rows in my spreadsheet (below each day). I only need for one row at a time to show up. My idea was to leave one row ready to input information, as information is inserted then the row below would unhide - when information is added to that row, then the row below it would unhide and so on. I looked at the autofilter function, I don't think it will work the way I want it to. Also, I don't want to have to click a button or anything to get this to work. I don't think the insert row will work, one I have a lot of auto-information applied & I also have additional sheets that are linked to data on this sheet, so changing row numbers wouldn't be good. I have attached a file for reference.

Thanks

Matt

I found this code on another forum

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Cells.Count > 1 Then Exit Sub

If Not Intersect(Target, Range("A38:A" & Rows.Count)) Is Nothing Then
If Target.Value = "" Then
Rows(Target.Row + 1).Hidden = True
Else
Rows(Target.Row + 1).Hidden = False
End If
End If

End Sub

I am going to try this, and I will reply to if I get it to work