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:then in my drop list should be months: 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

Absolutely no clue what you are talking about. Mock up a sheet and attach.