Conditionally Hiding Rows

L

Llobid

I appreciate your help. I have a spreadsheet that contains severa
worksheets. On one of the worksheets, the values in one column ar
determined by the results of an IF statement that looks at condition
in another worksheet.

The user wants a row in the dependent worksheet to be automaticall
hidden if the results of the IF statement are a certain value.

For example, if the IF statement in cell D8 returns "" (or blank), the
the user wants row D to be automatically hidden. Is there a way to d
this? I am not sure of the version of Excel he is using, but feel sur
it is 2000 or higher
 
B

Bryan Hessey

D is a column in most worksheets, did you mean to hide Row 8 (possible
with VBA code), or column D (not possible for your purposes)?

--
 
B

Bryan Hessey

The easy way is to select the first rown then Data, Filter, Auto-filter
and dropdown column D and select Non-Blanks.

--
Sorry ... yes, I meant row 8 ... NOT column D needs to be hidden.
Click to expand...
 
B

Bryan Hessey

The easy way is to select the first row then Data, Filter, Auto-filter
and dropdown column D and select Non-Blanks.

--
Sorry ... yes, I meant row 8 ... NOT column D needs to be hidden.
Click to expand...
 
L

Llobid

Thanks for your help; I have used the Excel filters before, but have
never noticed that specific capability. I really appreciate it.
 
Top