shunka8059
New Member
- Joined
- Aug 9, 2013
- Messages
- 7
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.
<tbody>
</tbody>
| List | Test | |||||||||||
| Region | Asia | America | Japan | China | USA | Region | Country | Places | Quantity | |||
| Asia | Japan | USA | Tokyo | Hong Kong | New York | America | USA | New York | ||||
| Ameria | China | Osaka | Beijing | Boston | Boston | |||||||
| Okinawa | Shanghai | Los Angeles | Los Angeles | |||||||||
| Kyoto | Houston | Houston | ||||||||||
| Kanagawa | Chicago | Chicago | ||||||||||
| Miami | Miami | |||||||||||
| Asia | Japan | Tokyo | ||||||||||
| Osaka | ||||||||||||
| Okinawa | ||||||||||||
| Kyoto | ||||||||||||
| Kanagawa |
<tbody>
</tbody>
