i want ranges to get selected automatically if i chooses a certain name in data validation drop list

[ahmed_saad]

i want ranges to get selected automatically if i chooses a certain name in data validation drop list... how to do that???
please help me
thanks in advance

 

[JoeMo]

In what cell is the data validation list, what is the certain name, and what range do you want to be selected?

 

[ahmed_saad]

 

[ahmed_saad]

for example: data validation list is in (c105 till c114)

range i want to select (f11) if i select C105 and range (q1:y1) if i select c106

<colgroup><col></colgroup><tbody>
</tbody>