0 votes
in VBA by Beginner (17 points)

bonjour,
Je dispose de deux fichiers
1- liste des SITE_LTE avec cordonnées GPS
2- Liste des utilisateurs avec cordonnées GPS
Je cherche une sorte de moulinette : "avec ou sans code VBA " qui va permettre de calculer la distance la plus proche entre chaque SITE_LTE et utilisateurs et rattaché chaque Site au utilisateur le plus proche. Sache que le nombre d'utilisateurs et plus grand que les sites.
Merciiiiiiii d'avance.

 

by Expert (911 points)
+1

Google translation:
Hello,
I have two files
1- list of SITE_LTE with GPS coordinates
2- List of users with GPS coordinates
I am looking for a sort of mill: "with or without VBA code" which will make it possible to calculate the closest distance between each SITE_LTE and users and attach each Site to the closest user. Know that the number of users is greater than the sites.
Merciiiiiiii in advance.

See earlier question: Find closest value

by Beginner (17 points)
Thank you for translate
by Expert (911 points)

Is this different from your earlier question: Find closest value? If so, how is it different? Please use the Table button to provde representative data from the worksheet(s) and/or use the Image button to add a screenshot of representative rows from the worksheet(s). Those buttons are on either side of the "Insert Code Snippet" button.

You might be interested in this article: Calculating the Distance Between Points

Please log in or register to answer this question.

Welcome to wellsr Q&A
Ask any questions you have about VBA and Python and our community will help answer them. wellsr Q&A is the standalone question and answer platform for wellsr.com. If you have a question about one of our specific tutorials, please include a link back to the tutorial.

Getting Started
Register
VBA Cheat Sheets (On Sale Now)

Looking for something else? Hire our team directly through ourVBA Help page, instead.

For more programming tips visit the VBA Tutorials Blog and the Python Tutorials Blog.

...