I have created a drop down list from another workbook. When I pick a name
from the drop down list I want to list the location also listed in the
original workbook. How would I do this?