Hi folks,
I've written a macro to hide certain columns depending on which month is selected from a drop-down menu
e.g.
If Jun-13 is selected, I would like the following columns to be visible:
D, E, F, G, I, K, M, O, Q, R, Y, Z, AA, AB
so that effectively we show all the preceding months actuals (ACT), Jun-13 actual & budget, always show Columns Y, Z, AA, AB regardless of which ever month is selected, e.g.
If Aug-13 is selected, I would like the following columns to be visible:
D, E, F, G, I, K, M, O, Q, S, U, V, Y, Z, AA, AB
I need a resolve pretty urgently so any help really appreciated
Thanks, Maddy :-)Hide_Col_Example.xlsm
Bookmarks