Hi,
I'm at biggner level excel usage and trying to set data validation for Years (Primary Validation) and months (secondary validation). Wishes to select year from drop-down list and then relevant months, however unable to do this. I don't know what i am doing wrong on earth . Also want to get secondary validation (months) to be dynamic in nature so that only previous or current month showing not the coming months of 2017.
I'm at biggner level excel usage and trying to set data validation for Years (Primary Validation) and months (secondary validation). Wishes to select year from drop-down list and then relevant months, however unable to do this. I don't know what i am doing wrong on earth . Also want to get secondary validation (months) to be dynamic in nature so that only previous or current month showing not the coming months of 2017.