jammer6_9
04-13-2008, 02:04 AM
Hi to everyone!
In cell B2 & B3 I have a Data Validation which give months (MMM)
In cel D4:O4 i have (JAN,FEB,MAR, --- to DEC)Now what i want is when I click Data validation in b2 (JAN) and Data Validation in b3 (JUN), JUL to DEC must be hidden. Or in short Column Visibility will be based on Data Validation value. :help I can I hide and unhide column if I will go with one Data Validation only but if I will take the range of two Data Validation, that is where I can not...
In cell B2 & B3 I have a Data Validation which give months (MMM)
In cel D4:O4 i have (JAN,FEB,MAR, --- to DEC)Now what i want is when I click Data validation in b2 (JAN) and Data Validation in b3 (JUN), JUL to DEC must be hidden. Or in short Column Visibility will be based on Data Validation value. :help I can I hide and unhide column if I will go with one Data Validation only but if I will take the range of two Data Validation, that is where I can not...