Address Sorting - using Excel Programming / VBA / Macros

Dnyan

Board Regular
Joined
Mar 25, 2010
Messages
90
I have a data file in which address is given and everyday I have to sort this data as per below:

Flat/Premise No, Building No, Building Name, Street Name, District Town, County, Country, Postcode like this.

I have to sort every day thousands of data, so is it possible to use any Shortcut/ Formula or Macro and sort all address as per above mentioned?

The attachment is given in below link
Address Sorting - using Excel Programming / VBA / Macros
 

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

oldbrewer

Well-known Member
Joined
Apr 11, 2010
Messages
11,005
not clear what you want - if original data is as above, how do you want to sort it

you can sort by eg postcode then county then town
 

Dnyan

Board Regular
Joined
Mar 25, 2010
Messages
90

ADVERTISEMENT

not clear what you want - if original data is as above, how do you want to sort it

you can sort by eg postcode then county then town

Hi

Want to sort all address as per given tabs in excel.
I used Text to column but every time address are different so not possible so please help me for the same
 

oldbrewer

Well-known Member
Joined
Apr 11, 2010
Messages
11,005
Flat/Premise No, Building No, Building Name, Street Name, District Town, County, Country, Postcode like this.

the above is what you have - how do you want to sort it? Spell it out for us (I personally do not download links etc)
 

Dnyan

Board Regular
Joined
Mar 25, 2010
Messages
90
Flat/Premise No, Building No, Building Name, Street Name, District Town, County, Country, Postcode like this.

the above is what you have - how do you want to sort it? Spell it out for us (I personally do not download links etc)

Manchester Road East Sussex United Kingdom AB12A 2SL

Bell Farm Lane Chesire United Kingdom BP14 5ZA

ABC Road Gydaad United Kingdom AK87 9SU

Engineers Road Middleast United Kingdom PS5 8EA


<colgroup><col></colgroup><tbody>
</tbody>
Want to sort above address as per below tabs
Flat/Premise NoBuilding NoBuilding NameStreet NameDistrictTownCountyCountryPostcode
Lower Ground, 1st, 2nd, 3rd Floors 1XYZ StreetLondonUnited KingdomPE9A 8ZP

<colgroup><col><col span="2"><col><col><col><col><col><col></colgroup><tbody>
</tbody>
 

oldbrewer

Well-known Member
Joined
Apr 11, 2010
Messages
11,005
as some addresses will have building number, and some building name, and some neither of these, and some both of these, and "streets" can also be called road, lane, close, avenue, etc, you cannot do this. Only your brain can do this degree of sorting. Text can be broken up by detecting words, spaces, commas etc but if one address is 4 ABC Road, another is ABC Road, another is Appartment 2, 4 ABC Road, excel cannot be used.
 

Forum statistics

Threads
1,137,298
Messages
5,680,684
Members
419,924
Latest member
Dhamodharan992

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top