Dear all,

I have a problem where I want to hide certain whole columns automatically where a date in the cells between B4:I4 is greater than the 'current date' in cell A3 [i.e. cell A3 has the value of "=NOW()"] and to show those same whole columns automatically where a date in the cells between B4:I4 is less than the current date.

That is, for example:

A3 =
2 December 2011 at 4:45 PM

B4= C4= D4= E4= F4= G4= H4= I4=
1-Apr-11 1-May-11 1-Jul-11 1-Sep-11 1-Oct-11 1-Dec-11 1-Feb-12 1-Apr-12

So in the the above example, whole columns H:I should hide as the value in the cells in each of H4:I4 is greater than the current date in A3 whereas columns B:G should show as the value in the cells in each of B4:G4 is less than the current date in A3.

Does anyone know how this can be achieved (I assume a macro/VB script is required)? And how it can be achieved automatically (i.e. much the same as formulas update automatically)?

Thanks in advance!

Best regards,
Chris