This can't be done with the drop downs created simply with data validation. It can be done with List Box form control. However, you would have to make one for each record so it's not really esthetic.

On the other hand, you might be able to work something using data relationships. I don't think this is available in my Excel but I see you have 2013.

http://www.pcworld.com/article/24622...xcel-2013.html

It also may be done using a pivot table.

http://superuser.com/questions/47346...lls-in-a-large