Summarizing Australian Postcodes

[mikeconomy]

Hi All,

Back again with another post code issue

what i need to do with the attached report is

find out how many localities are a certain postcode then have them automatically concatenate into one cell with ", " Separating them so that the final 2 cells look as below


810 I ALAWA, BRINKIN, CASUARINA, COCONUT GROVE, JINGILI, LEE POINT

I need this to be update-able so if the post code lists change I Can drop a new list in and it will repopulate the data with the updated postcodes

any help would be greatly appreciated

[nathansav]

I would have a pivot table (or make sure the list is somewhere sorted into the postcode order and run off that) created off your postcodes and localities, the vba code run down the post code and that post code stays until a new one is detected, and a string of the localities is create. If a new one is detected the string is placed in the workbook, and then the next one.

[Leith Ross]

Hello mikeconomy,

Welcome to the Forum!

I added a another worksheet to your workbook named "Summary". This also has a button added to run the macro below. This will list all the post codes with the all the associated localities in the cell to the right. The localities are separated by commas.

Please Login or Register  to view this content.

[mikeconomy]

Leith ,

I just want to say thank you , this code is amazing does exactly what I need your a brilliant and your code is elegant too.

Once again thank you developing a resolution to my problem.


Mike

[Leith Ross]

Hello Mike,

If you like the results, you can leave a tip in the jar . Glad I could help. Thanks for the kind words.