maps

  1. G

    Address spreadsheet to maps

    I have a list of addresses 100ish. Is there a way to vba from Excel to map out a route to follow in Google maps, Waze, Bing maps, it any other option.
  2. S

    Adding new Geographical Boundries to Excel Map

    Hi, I would like to add an LGA map on top to create new geographical boundries and names. Eg. an Local Government Area can be a combination of more than one or multiple postcode. I have downloaded the shape files from government websites but I am unable to create custom region maps as per...
  3. H

    Excel Maps

    Evening all, I hope you can help. I am trying to enter details for a region of South England, United Kingdom and pull this information in to a map using Excel Maps. However I can only get the map to show England, Scotland, etc and not the counties. I am trying to add A1 - Reading A2 - Swindon...
  4. O

    Inserting an image from google maps based on a URL in a cell

    Hi, I have data from a data base that I export into excel and paste into an excel spreadsheet which formats the data to look presentable. The data has a google maps location URL column and I would like to write some VBA based on the cells with the URL to insert a satellite image of this...
  5. A

    Adjusting the layout of disparate data in excel

    Not sure if that title is the snappiest way to label this query. I have results from a questionnaire which are partly about jurisdictions of interest of businesses. As shown (poorly) below, they way they have been pulled in to excel makes it quite difficult to interact with them. The businesses...
  6. W

    Cannot Show 3D Map (Region) State Labels?

    Hey there! I'm looking to migrate one of my 2D map charts into the new(ish) 3D Maps. It's a veeeeery standard territory map of the USA, so I'm using the Region type map. Now, here's the odd part: while you can enable "Map Labels" (main toolbar on the Home ribbon), that only adds the Bing maps...
  7. M

    city not available in Excel maps

    Hi, I will use Excel maps for my data, but 1 city (Izmir) is not available in Turkey map. i write the name of the city right, all other cities are now colored except Izmir. How can i find the defined name in maps-turkey for Izmir. BR, Metin
  8. JenniferMurphy

    Curve fitting problem

    I know this is technically not an Excel question, but there are a lot of people here with better math skills than mine, so I hope this is OK. I would like to find a family of functions, f(x,m), that meets these conditions: Maps the domain (0,10) onto the same range and is continuous over that...
  9. G

    Help with Macro that Moves Shape

    I have a spreadsheet with 20 charts, each comparing one of our products vs similar products from our competitors, as well as a map for each competitor. The charts run along the right side of the spreadsheet with the map on the left side. A drop down menu allows you to toggle between maps. The...
  10. L

    3D Maps Custom Region

    Hi All, I am trying to create a map of the US with custom regions. For example "New England" = (Maine (ME), Massachusetts (MA), etc) and ("Pacific" = California (CA), Oregon (OR) etc.) I am not really sure where to start. I understand I need a KML or SHP file, but I am not really sure how to...
  11. P

    Export a spreadsheet into google maps

    Hey there, So I have a spreadsheet right now that looks like this: <colgroup><col span="5"></colgroup><tbody> Name Surname Company Income Address John Smith General Motors 100000 (Address1) Peter Jackson Hilton Hotels 70000 (Address1) Peter Jackson Hilton Hotels 70000 (Address2)...
  12. F

    Google Maps Data

    Hello there, I’m not sure this is possible (or even strictly legal), but I’ll ask in the vain hope it is. Is there an automated way to collect data from Google maps into Excel? I have a starting point (location/post code) in Cell A2, and a destination in Cell B2 (location/post code). I...
  13. A

    Calculating Distances between Postcodes

    I need to calculate the distances between my company head office and a range of customer addresses. Is there a way of doing this in excel perhaps using google maps?. I am in the UK so the distance needs to be calculated between postcodes.
  14. T

    Animated Progress Bar For Map

    Morning, I'm looking for suggestions to achieve the following situation: We are having a charity bike rid from John O Grote's to Lands End on a stationary bike. We would like to display the progress from the bike ride on a TV from Excel. So a value of miles done will be entered regularly be it...
  15. J

    Google Directions API Map Image

    Hi I have vba code that will give me the driving time and the detailed directions between two addresses but I cant seem to pull through the image of the google Map showing this. I can find threads on static maps pinpointing locations or streetview but nothing on how to pull this image back...
  16. HowlingWulf

    Hyperlinking a Mileage Calculator

    Good Morning, I am trying to hyperlink to google maps but in doing so I am also trying to substitute two values (postcodes) on my spreadsheet into the address from and the address to. For example: =HYPERLINK("https://maps.google.co.uk/maps?saddr="&SUBSTITUTE(C8,"...
  17. D

    Time field disappears when add location data to 3D Maps Excel 2016

    Hello all, I'd appreciate any help solving the below mystery... I'm using Excel 2016 (in Windows) and have the 3D Maps functionality for the first time. I want to show progress over time by adding both location data (address inc. postcode or just postcode) and the date or month that point was...
  18. M

    Using Excel with maps

    Hello, I am newer to more advanced Excel topics. I have a set of 8000 or so locations (each includes street address, city, state, county, latitude, and longitude). I have been tasked with finding out how many of these locations are between the Mississippi River and the Rocky Mountains. Anyone...
  19. O

    Connecting Map Plot Points

    Hi All, I've got a big table of data and within it I've used 'post code' to plot points on a map using PowerView. These locations were visited in order and it would be very useful to see in what order they were visited - preferably by connecting them with a line (either as the crow flies...
  20. J

    Need Mileage calculator using Google Maps and MS Excel

    Hello, I'm looking to create a mileage calculator in Excel using Google Maps, depending on how many addresses I input, I would like Excel to return a total trip mileage. I'm not interested in having this do anything else, I want to keep it simple, would not mind if in Excel I see a snapshot or...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top