Calculate distance between multiple locations using latitude and longitude

Yes please

I would like to use the output for an optimisation exercise using solver and macros as a final output.

I intend to create an additional column next to each location titled availability which picks up if an area is under or over utilised. Those areas under utilised will have <100% utilisations and vice versa. The intention is to resign availability based on the distance between location which is why I need the grid or matrix. I'm hoping to finally create a macro which can use solver and the location grid to determine the idea reallocation of resources.

for example, area A is only 5 miles away from area B. Area A is under utilised by 95% while area B is over utilised by 105%, therefore as they are within 5 miles the macro will recommend to allocate 5% from area B to area A.

Awesome, this is exactly what i was looking for. Thank you so much. I've added an additional column with sample figures in the column titled utilisation. Is it possible to build a macro using solver to determine the best way to reallocate optimally. For example, I would like the tool to identify locations within 5 miles which have imbalanced utilisation so that these can be relocated accordingly.

For example location A and B are within 5 miles. Location A has 105 while location B in at 95. Therefore i'd like solver/macro to reallocate 5 from location A to location B so that both are at 100%.

The recommendation can be in a new column. Is this possible? Apologies, not sure if i need to start a new thread. Happy to close this one as solved before asking the extension question.