Excel: Hide columns based on value in cell

Hi, I want to hide unhide columns based on the criteria given in the cell for eg: my cell a1 has programme life eg 5 years, so the columns for only five years should be visible and the rest of the columns, viz the rest 10 years, should be auto hidden. Thanks in advance......

This question generated 21 answers. To proceed to the answers, click here.

This thread is current as of May 13, 2014.

For more resources for Microsoft Excel