Post Code Mapping

[DWNewmac]

Hi,

I have a spreadsheet with upwards of 1,000 postcodes that will change (both in volume and postcodes themselves) as items are added or removed.

I'd like to be able to view these as pins in a UK and Ireland map (ideally with different colours for the pins depending on various criteria - for example; priority, company name, job type etc. As the data in the spreadsheet will continually be updated, I'd also like to be able to refresh the map to reflect the changes.

Is this something that is achievable through Excel? I've played with the Bing Add-In but this appears to limit me to a maximum of 100 postcodes.

Thanks

David

 

[mole999]

can't say I have seen a UK postcode map for excel

 

[alansidman]

I have not worked with Power Map, but this may be an area to research as it links directly with Excel and is a Microsoft Product part of the Power Series.

 

[Kyle123]

Yes, you can use the 3D map in Excel to do this, works better with lat and long though

 

[DWNewmac]

Thanks all for the replies - I'll have a look into the recommendations.

David