Hi,

I would like to create a macro so that columns in another worksheet (within the same book) automatically hide if a value in a certain cell is "y" or "n".

Example:

Automatically hide column j in worksheet 2 if cell c2 in worksheet 1 is "y".



If anyone knows of a mcaro please let me know.

Thanks!