3D Maps - Postcode Region

[edavies2]

Hi All,

I've been trying to find out a way to do this for some time now but, have hit a brick wall so I'm hoping someone may be able to help!

I have a set of data which has about 2500 clients in it, which needs to be divided into UK regions so I can allocate it to different members of staff. I need to know how many clients we have in each UK Region. The Data I have does not include which region of the UK the client is located but, it does have their Postcode (I have separated out the Prefix). I have tried using Mass replace codes and adding KML files to 3D Maps but nothing seems to work, any advice would be greatly appreciated.

Thank you!

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: 3D Maps
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[edavies2]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: 3D Maps
If you have posted the question at more places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

So sorry!!! Thank you for letting me know.