Hiding rows
Manually / Automatically?
One way would be to use a helper column and then have an IF statement or
perhaps a VLOOKUP, that returned a value such as "Show" or "Hide" based on
whatever criteria you want to set. You can then just use Data / Filter /
Autofilter to show just the "Show"s
--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------
It's easier to beg forgiveness than ask permission :-)
"bobb" wrote:
Is there any way to hide a single row based on a value in the row? Or in a
value in another row?
|