Automatically Hide rows on Sheet 2 conditional to data on Sheet 1

[Ctralha]

Hi, I'm trying to hide rows on an excel worksheet ("ERRORS") based on whether or not a specific cell of another worksheet ("WORKFLOW") is empty. i.e.: If cell I2 of worksheet ("WORKFLOW") has any value (if it is not empty) , row 2 on worksheet ("ERRORS") should be visible. If it has no value (is empty), row 2 on worksheet ("ERRORS") should be hidden. The code should repeat itself, so that row 5 depends on I5, row 6 on I6 and so on.

I would like the rows to be visible/hidden automatically as information is added to worksheet ("WORKFLOW".

Thank you in advance for the assistance!

 

[Michael M]

Maybe something like this, pasted into the WORKFLOW sheet module

Private Sub Worksheet_change(ByVal Target As Range)
If Intersect(Target, Range("I:I")) Is Nothing Then Exit Sub
If Target.Value = "" Then
Sheets("ERRORS").Rows(Target.Row).EntireRow.Hidden = True
Else
Sheets("ERRORS").Rows(Target.Row).EntireRow.Hidden = False
End If
End Sub