Good day, I currently have a piece of VB code that will get me the distance between 2 cities.
Thinking I can use this I now need to take the install city/country input (C4) and generate a list out the Depot City/country locations (closest to furthest) based off a sheet of depots that are listed by city/country
then I need the result list to be displayed in 2 columns (broken out by city F3 and country G4)
Here is the code I am currently using.
Please Login or Register to view this content.
Any suggestions
Thanks in advance
Bookmarks