hi
give your range of names a dinamic_range_name and on data validation choose the list and for reference give that dinamic range name.
Avner