Thanks, but for now I think I'm just going to drop those cells down on the
sheet so that if they get cut in printing it's not a big deal.

"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?