excel - Default Data Validation -

i have report want display information on selected hierarchy. have data validation select: geography or products. - if geography selected - second data validation displays list of products - if products selected - second data validation displays list of geography.

the data validations contain correct lists (i used defined names each hierarchy , data validations use list indirect of list).

the problem when select different hierarchy - reports doesn't display data until value selected second data validation. want second data validation set default value first value in list (or value exists in list).

is there solution or vba code this? until have this:

private sub worksheet_change(byval target range) if not intersect(target, monthlysellin.range("b4") application.enableevents = false if range("$b$4").value = "geography"         monthlysellin("b7").validation            .delete            .add type:=xlvalidatelist, alertstyle:=xlvalidalertstop, operator:= _               xlbetween, formula1:="=legend!$d$3:$d$83"           end     elseif range("$b$4").value = "brand"          monthlysellin("b7").validation         .delete            .add type:=xlvalidatelist, alertstyle:=xlvalidalertstop, operator:= _               xlbetween, formula1:="=legend!$i$3:$i$50"           end      end if end if application.enableevents = true  end sub