Iterate through list...

[davekite]

I would like to create a workbook that contains a list of countries in Europe.

Then, elsewhere in the workbook, I will have a selection list where one of the countries can be selected...and once a country is selected the entire list of countries would be returned in another list in the order that they border each other.

For example, if the list contained Spain, France, Belgium, Netherlands, Germany, Switzerland, Italy, and Belgium is selected as the first country, then the other countries should be returned in a list that is ordered by the way that they border each other. So the returned list could look like:

Belgium, Netherlands, Germany, Switzerland, Italy, France and Spain. (note if there is more than one border then it doesn't matter which path the list takes).

Any ideas as to the most efficient way to do this?

Hope this makes some sense!

[PeteABC123]

Here's a place to gather a formula:

http://office.microsoft.com/en-us/ex...#_Toc273640147

Gather your Country borders from Wiki:
http://en.wikipedia.org/wiki/List_of...y_land_borders

That should get you started.
Pete