Filter/Hide
There is no native way in Excel to hide columns based on some value,
so you would need a macro to do this for you.
Pete
On Oct 29, 2:21*pm, Neil Pearce wrote:
Autofilter can hide rows. *Is there a way to hide columns based on the inputs
of a particular row?
i.e. columns E-Z contain information to be filtered, if cells in row 6
contain either a 0 or 1, is it possible to hide the columns containing 0?
Thanking-you in advance,
Neil *
|