Executes on opening workbook

Sub Auto_Open()

lastrow = Cells(Rows.Count, "C").End(xlUp).Row
Set rnga = Range("C1:C" & lastrow) ' Assume data starts in row 1

For Each c In rnga ' Check C & D for empty and hide row if
both empty
If WorksheetFunction.And(c = "", c.Offset(0, 1) = "") Then
Rows(c.Row).EntireRow.Hidden = True
End If
Next c
End Sub

Hope this helps.



"Brad" wrote:

actually, on second thought, is that hard to do? I might consider it.

"JulieD" wrote:

Hi Brad

the only other alternative to Don's suggestion is to use code - which could
run automatically on the opening of the workbook or the selection of the
sheet. However, this does mean that the users have to have enabled macros
(and security settings need to be set to medium).

is this an approach you're interested in?

Cheers
JulieD

"Brad" wrote in message
...
this is not what I'm looking for. I'm looking for no human intervension.

"Don Guillett" wrote:

try it

--
Don Guillett
SalesAid Software

"Brad" wrote in message
...
Will this filter automatically once the vlookups update?

"Don Guillett" wrote:

Formulas cannot do this. They only return values. suggest using
datafilterautofilter and then filter as desired.

--
Don Guillett
SalesAid Software

"Brad" wrote in message
...
I have a list of sales people in a worksheet and I only want the
ones
with
info in column c or column d to show up. If both are empty I don't
want
them
to show. Is there a formula that will hide the row if their is no
data
in
either of these cells?