Yes, for instance if I enter data into A2 then row 2 would br hidden
but not if I enter data into B2 etc.

I've used AutoFilter for this.

Select column A and use
Data Filter AutoFilter
This adds a pull-down arrow at A1 and lets you show rows with blanks in
column A (for example). After making a change in column A, click the pull-
down arrow again.

By the way, is there something as easy as this for columns rather than
rows? I saw a posting that suggested a macro, but I'd prefer something like
AutoFilter.