Can you apply Data|Filter|Autofilter
and do a custom filter of not equal to 0?
(Not quite automatic, but pretty darn effective.)
Maxwell Sprinkler wrote:
I'd like for Excel to automaticalliy hide a row if the value in a given cell
is equal to zero.
--
Dave Peterson
|