|We will need a more detailed description of your data layout before we could offer any help. Items such as which column contains your locations, etc.|
If you are going to post an example of your data, please click on the following link and read the instructions on how to post data in this forum. Thanks!
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.