geocode

Hi all, im attempting to use the website https://www.doogal.co.uk/BatchGeocoding.php to take a list of postcodes in column A and either take the results straight from the website and paste into B and C. Or download the csv File and import into the correct columns. Sub geoCode() Dim IE As...

I have a data dump of sales transactions with corresponding dollar values and delivery coordinates (latitude and longitude). I'd like to run some form of cluster analysis to output a ranked listing of where the highest to lowest density of sales is based on an input of an X-mile radius. I'm...

Hi Everyone, I am very new to Excel Vba and to this forum. I really need help in one of the macros that I want to write as part of my internship work. I have a list (1125) of latitude and longitude of addresses. I want to write a macro, which will give me the distance between two latitudes and...

I want to the do following: 1. Make a spreadsheet that enters a postcode 2. This then converts this to a geocode format that will be able to be cut and paste into google earth. So quite simple I think but how does one do this? What data do I need?