Hello, i am trying to create a excel sheet with a validation drop down list in a cell wich values depend of other cell value, i read a tutorial that tell me about Dependent Data Validation, but in my case i need use interval values, for example:
i have a initial month and a last month, in two periods, and i need that cell in column B2 they may be only eligible values from that interval in a drop down list.
Example:
Code:
interval A1=january, A2=march, so january to march
and a3=september a4= november, next interval september to november
then in my drop list should be months:
Code:
january, february, march, september, november
Then in next column, C2:C, i have numeric values that show numbers of weeks workables in that month.
, it mean that if i choice in another sheet i choice august for month in drop list should be
, for number of week
there is a way that can i do that?
thz.
PS: I am using office 2013 and windows 8