Drop down bar to hide column according to the content of a cell
Hi all,
I need help. How can i write a macro such that
when the user select (e.g. 2 ) from the dropdown for, it hides column
G:Z
when the user select (e.g. 5) from the dropdown form, it hides Column
J:Z
Thank you so much.
Cheers
WL
|