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