Hi,

I would like to know if it is possible to hide Column/Row based on If condition. (If the cell A1 has a particular value then hide ColumnB).

Incase this isn't possible, can you help me with this problem -

I'm having a drop down list with Jan-Dec in Cell A1. In Cells B2:G10, I need to input a value corresponding to each of the months. This value I'm retreiving and using in a different location using If Condition. The problem is that incase I change the month to Feb, the values inputted for Jan remains the same throughout. Any change made for Feb gets reflected throughout. I'm not able to tie Jan-Dec to the Cell values in B2"G10.

How to retain the values, specific for each of the months. The inputted data should remain the same, even if I change the value in A1

The simple way out would be to have Jan-Dec in separate cells but I feel that this would make the data entry screen big and complicated for the end user. In case no month is selected a default value is choosen.

Is there any other way out to input the data and retrive it elsewhere?