Showing and hiding columns
I need help hiding and showing columns based on a cell value. When my
workbook opens column H and I are hidden. Cell C1 is a cell that I have
validation. When the user selects "THIS" in cell C1 I would like column H to
appear. If the user selects "THAT" in cell C1 then I want column I to appear
and column H to be hidden. Can this be done?
T.I.A.
Ed
|