Auto fill in with data list after choosing from a drop down list

[shunka8059]

Hi, I was wondering if there's a way for excel to fill up a column with data which is dependent on the drop down list choice? For example, in the below picture, I chose America in Region column, which consequently will lead to a series of countries to choose. I chose USA. Now, the question is whether excel can automatically input New York, Boston, Los Angeles, Houston, Chicago, Miami just as soon as I finish choosing USA. [TABLE="width: 500"]
<tbody>[TR]
[TD]List[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Test[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Region
[/TD]
[TD]Asia
[/TD]
[TD]America
[/TD]
[TD]Japan
[/TD]
[TD]China
[/TD]
[TD]USA
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Region
[/TD]
[TD]Country
[/TD]
[TD]Places
[/TD]
[TD]Quantity
[/TD]
[/TR]
[TR]
[TD]Asia
[/TD]
[TD]Japan
[/TD]
[TD]USA
[/TD]
[TD]Tokyo
[/TD]
[TD]Hong Kong
[/TD]
[TD]New York
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]America
[/TD]
[TD]USA
[/TD]
[TD]New York
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Ameria
[/TD]
[TD]China
[/TD]
[TD][/TD]
[TD]Osaka
[/TD]
[TD]Beijing
[/TD]
[TD]Boston
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Boston
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Okinawa
[/TD]
[TD]Shanghai
[/TD]
[TD]Los Angeles
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Los Angeles
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Kyoto
[/TD]
[TD][/TD]
[TD]Houston
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Houston
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Kanagawa
[/TD]
[TD][/TD]
[TD]Chicago
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Chicago
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Miami
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Miami
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Asia
[/TD]
[TD]Japan
[/TD]
[TD]Tokyo
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Osaka
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Okinawa
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Kyoto
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Kanagawa
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]