Hi,

A worksheet contains data as follows:

Column A ColumnnB
Country1 $B$24:$B$30
Country2 $B$9:$B$18
Country3 $B$42:$B$51
and so on

Column B has the range in another sheet where the list of States/
counties in the corresponding country are stored

When the user clicks in the corresponding cell in Column C,a dropdown
list should display the names in the range in column B and validate
that only one of those values is input.

How can this be achieved through VBA?

Thanks in advance for the Help.

Regards,
Raj