Spreadsheet: 107953d1305074435-excel-2007-vba-script-needed-example
Sheet: Sheet1

Matched Postcode A | [NAME] A | Unmatched Postcode | New matched division
1480 | STGEO | 1750 | PARRA
1481 | STGEO | 1755 | PARRA
1485 | STGEO | 1765 | PARRA
1490 | CRONULLA | 1805 | WEST
1495 | CRONULLA | 1811 | PARRA
1499 | CRONULLA | 1860 | STGEO
1515 | NORTHERN | 1885 | STGEO
1560 | NORTHERN | 1888
1565 | NORTHERN | 1890
1570 | NORTHERN | 2000
1585 | NORTHERN | 2000
1590 | NORTHERN | 2000
1595 | NORTHERN | 2000
1630 | NORTHERN | 2000
1635 | NORTHERN | 2000
1640 | MANLY | 2007
1655 | MANLY | 2015
1660 | MANLY | 2019
1670 | NORTHERN | 2022
1675 | NORTHERN | 2022
1680 | NORTHERN | 2022
1685 | NORTHERN | 2023
1700 | NORTHERN | 2030
1701 | PARRA | 2030
1710 | PARRA | 2030
1715 | PARRA | 2037
1730 | PARRA | 2037
1750 | PARRA | 2037
1755 | PARRA | 2038
1765 | PARRA | 2039
1790 | PARRA | 2044
1800 | WEST | 2044
1805 | WEST | 2044
1811 | PARRA | 2046
1816 | WEST | 2047
1825 | WEST | 2066
1835 | PARRA | 2067
1851 | PARRA | 2069
1860 | STGEO | 2077
1871 | PARRA | 2077
1875 | PARRA | 2077
1885 | STGEO | 2079
1890 | PARRA | 2089
1891 | STGEO | 2093
2000 | SYDNEY | 2093
2000 | SYDNEY | 2095
2000 | SYDNEY | 2097
2000 | SYDNEY | 2099
2000 | SYDNEY | 2100
2000 | SYDNEY | 2100
2000 | SYDNEY | 2100
2000 | SYDNEY | 2102
2001 | SYDNEY | 2111
2002 | SYDNEY | 2111
2004 | SYDNEY | 2111
2006 | SYDNEY | 2111
2007 | SYDNEY | 2112
2007 | SYDNEY | 2112
2008 | SYDNEY | 2113
2008 | SYDNEY | 2113
2009 | SYDNEY | 2113
2010 | SYDNEY | 2120
2010 | SYDNEY | 2123
2010 | SYDNEY | 2123
2011 | SYDNEY | 2125
2011 | SYDNEY | 2127
2011 | SYDNEY | 2128
2011 | SYDNEY | 2128
2011 | SYDNEY | 2128
2012 | SYDNEY | 2128
2015 | SYDNEY | 2132
2015 | SYDNEY | 2133
2015 | SYDNEY | 2133
2016 | SYDNEY | 2135
2017 | SYDNEY | 2136
2017 | SYDNEY | 2137
2018 | EAST | 2137
2018 | EAST | 2137
2019 | EAST | 2141
2019 | EAST | 2141
2020 | EAST | 2142
2021 | EAST | 2142
2021 | EAST | 2142
2021 | SYDNEY | 2142
2022 | EAST | 2142
2023 | EAST | 2142
2024 | EAST | 2142
2024 | EAST | 2143
2025 | EAST | 2145
2026 | EAST | 2145
2026 | EAST | 2145
2026 | EAST | 2145
2026 | EAST | 2147
2027 | SYDNEY | 2147
2027 | SYDNEY | 2150
2027 | SYDNEY | 2150
2028 | EAST | 2150
2029 | EAST | 2150
2030 | EAST | 2151
2030 | EAST | 2151
2030 | EAST | 2152
2030 | EAST | 2153
2031 | EAST | 2153
2031 | EAST | 2153
2031 | EAST | 2153
2031 | EAST | 2153
2032 | EAST | 2153
2032 | EAST | 2155
2033 | EAST | 2156
2034 | EAST | 2156
2034 | EAST | 2157
2035 | EAST | 2160
2035 | EAST | 2160
2035 | EAST | 2160
2036 | EAST | 2160
2036 | EAST | 2161
2036 | EAST | 2161
2036 | EAST | 2161
2036 | EAST | 2161
2036 | EAST | 2164
2036 | EAST | 2165
2036 | EAST | 2165
2037 | SYDNEY | 2165
2037 | SYDNEY | 2165
2038 | SYDNEY | 2165
2039 | SYDNEY | 2166
2040 | SYDNEY | 2166
2040 | SYDNEY | 2170
2041 | SYDNEY | 2170
2041 | SYDNEY | 2171
2041 | SYDNEY | 2176
2042 | SYDNEY | 2176
2042 | SYDNEY | 2176
2043 | SYDNEY | 2190
2044 | WEST | 2190
2044 | WEST | 2190
2044 | WEST | 2192
2045 | WEST | 2192
2046 | WEST | 2193
2046 | WEST | 2193
2046 | WEST | 2194
2046 | WEST | 2194
2046 | WEST | 2194
2046 | WEST | 2194
2046 | WEST | 2194
2047 | WEST | 2196
2048 | WEST | 2199
2048 | WEST | 2200
2049 | WEST | 2200
2049 | WEST | 2200
2049 | WEST | 2200
2050 | SYDNEY | 2200
2050 | SYDNEY | 2206
2055 | NORTHERN | 2210
2057 | NORTHERN | 2211
2058 | NORTHERN | 2211
2059 | NORTHERN | 2212
2060 | NORTHERN | 2220
2060 | NORTHERN | 2220
2060 | NORTHERN | 2220
2060 | NORTHERN | 2224
2060 | NORTHERN | 2230
2061 | NORTHERN | 2230
2061 | NORTHERN | 2231
2062 | NORTHERN | 2231
2063 | NORTHERN | 2232
2064 | NORTHERN | 2232
2065 | NORTHERN | 2232
2065 | NORTHERN | 2232
2065 | NORTHERN | 2233
2065 | NORTHERN | 2233
2066 | NORTHERN | 2250
2066 | NORTHERN | 2250
2066 | NORTHERN | 2250
2066 | NORTHERN | 2250
2066 | NORTHERN | 2250
2066 | NORTHERN | 2250
2066 | NORTHERN | 2251
2067 | NORTHERN | 2251
2067 | NORTHERN | 2256
2068 | NORTHERN | 2256
2068 | NORTHERN | 2259
2068 | NORTHERN | 2259
2068 | NORTHERN | 2259
2068 | NORTHERN | 2259
2068 | NORTHERN | 2259
2069 | NORTHERN | 2259
2069 | NORTHERN | 2259
2069 | NORTHERN | 2259
2070 | NORTHERN | 2259
2070 | NORTHERN | 2259
2070 | NORTHERN | 2259
2071 | NORTHERN | 2259
2071 | NORTHERN | 2261
2072 | NORTHERN | 2261
2073 | NORTHERN | 2264
2073 | NORTHERN | 2264
2074 | MANLY | 2264
2074 | NORTHERN | 2264
2074 | NORTHERN | 2264
2074 | NORTHERN | 2282
2074 | NORTHERN | 2282
2075 | NORTHERN | 2282
2075 | NORTHERN | 2282
2076 | NORTHERN | 2282
2076 | NORTHERN | 2283
2076 | NORTHERN | 2283
2077 | NORTHERN | 2284
2077 | NORTHERN | 2285
2077 | NORTHERN | 2285
2077 | NORTHERN | 2285
2079 | NORTHERN | 2286
2080 | NORTHERN | 2287
2081 | NORTHERN | 2287
2081 | NORTHERN | 2287
2082 | NORTHERN | 2289
2082 | NORTHERN | 2290
2082 | NORTHERN | 2294
2083 | CENTCST | 2294
2083 | CENTCST | 2294
2083 | CENTCST | 2299
2083 | CENTCST | 2303
2083 | CENTCST | 2304
2083 | CENTCST | 2304
2083 | CENTCST | 2304
2084 | MANLY | 2304
2084 | MANLY | 2320
2084 | MANLY | 2320
2085 | MANLY | 2320
2085 | MANLY | 2322
2085 | MANLY | 2323
2086 | MANLY | 2323
2086 | MANLY | 2323
2087 | MANLY | 2327
2087 | MANLY | 2333
2088 | NORTHERN | 2333
2088 | NORTHERN | 2333
2089 | NORTHERN | 2335
2089 | NORTHERN | 2340
2090 | NORTHERN | 2340
2090 | NORTHERN | 2340
2090 | NORTHERN | 2340
2092 | MANLY | 2380
2093 | MANLY | 2380
2093 | MANLY | 2400
2093 | MANLY | 2427
2093 | MANLY | 2430
2093 | MANLY | 2430
2094 | MANLY | 2430
2095 | MANLY | 2440
2095 | MANLY | 2444
2096 | MANLY | 2444
2096 | MANLY | 2450
2096 | MANLY | 2450
2097 | MANLY | 2450
2097 | MANLY | 2450
2097 | MANLY | 2454
2097 | MANLY | 2460
2099 | MANLY | 2460
2099 | MANLY | 2478
2099 | MANLY | 2478
2099 | MANLY | 2478
2099 | MANLY | 2478
2100 | MANLY | 2480
2100 | MANLY | 2480
2100 | MANLY | 2482
2100 | MANLY | 2485
2100 | MANLY | 2485
2101 | MANLY | 2486
2101 | MANLY | 2486
2101 | MANLY | 2487
2101 | MANLY | 2487
2101 | MANLY | 2500
2102 | MANLY | 2502
2102 | MANLY | 2505
2103 | MANLY | 2505
2104 | MANLY | 2518
2105 | MANLY | 2518
2105 | MANLY | 2526
2105 | MANLY | 2526
2105 | MANLY | 2526
2105 | MANLY | 2526
2106 | MANLY | 2527
2106 | MANLY | 2529
2107 | MANLY | 2530
2107 | MANLY | 2530
2107 | MANLY | 2533
2107 | MANLY | 2536
2107 | MANLY | 2537
2107 | MANLY | 2537
2107 | MANLY | 2538
2108 | MANLY | 2539
2108 | MANLY | 2540
2108 | MANLY | 2540
2109 | NORTHERN | 2541
2110 | NORTHERN | 2541
2110 | NORTHERN | 2556
2111 | NORTHERN | 2556
2111 | NORTHERN | 2556
2111 | NORTHERN | 2565
2111 | NORTHERN | 2565
2111 | NORTHERN | 2566
2111 | NORTHERN | 2566
2111 | WEST | 2570
2112 | NORTHERN | 2575
2112 | NORTHERN | 2576
2112 | NORTHERN | 2577
2113 | NORTHERN | 2577
2113 | NORTHERN | 2577
2113 | NORTHERN | 2594
2113 | NORTHERN | 2620
2113 | NORTHERN | 2650
2114 | NORTHERN | 2650
2114 | NORTHERN | 2652
2114 | NORTHERN | 2710
2114 | NORTHERN | 2712
2114 | NORTHERN | 2721
2115 | NORTHERN | 2732
2116 | PARRA | 2745
2117 | PARRA | 2745
2117 | PARRA | 2750
2117 | PARRA | 2753
2117 | PARRA | 2756
2118 | PARRA | 2756
2118 | PARRA | 2760
2118 | PARRA | 2760
2118 | PARRA | 2765
2119 | PARRA | 2765
2119 | PARRA | 2774
2120 | PARRA | 2780
2120 | PARRA | 2795
2120 | PARRA | 2795
2121 | PARRA | 2795
2121 | PARRA | 2795
2122 | NORTHERN | 2799
2122 | NORTHERN | 2800
2123 | PARRA | 2800
2124 | PARRA | 2800
2125 | PARRA | 2810
2126 | PARRA | 2870
2127 | WEST | 1350
2127 | WEST | 1355
2127 | WEST | 1475
2128 | PARRA | 1655
2129 | PARRA | 1660
2129 | SYDNEY | 1680
2130 | WEST | 1701
2131 | WEST | 1750
2132 | WEST | 1885
2133 | WEST | 2000
2133 | WEST | 2000
2134 | WEST | 2000
2134 | WEST | 2000
2135 | WEST | 2000
2136 | STGEO | 2000
2136 | WEST | 2000
2136 | WEST | 2000
2137 | WEST | 2000
2137 | WEST | 2001
2137 | WEST | 2007
2137 | WEST | 2015
2137 | WEST | 2015
2138 | WEST | 2015
2138 | WEST | 2017
2138 | WEST | 2019
2140 | WEST | 2019
2140 | WEST | 2019
2140 | WEST | 2022
2141 | WEST | 2022
2141 | WEST | 2026
2141 | WEST | 2030
2141 | WEST | 2031
2142 | PARRA | 2033
2142 | PARRA | 2035
2142 | PARRA | 2035
2142 | PARRA | 2038
2142 | PARRA | 2038
2142 | PARRA | 2041
2142 | PARRA | 2044
2143 | PARRA | 2044
2143 | PARRA | 2060
2143 | PARRA | 2060
2144 | PARRA | 2066
2145 | PARRA | 2067
2145 | PARRA | 2070
2145 | PARRA | 2076
2145 | PARRA | 2076
2145 | PARRA | 2079
2145 | PARRA | 2093
2145 | PARRA | 2095
2145 | PARRA | 2097
2146 | PARRA | 2097
2146 | PARRA | 2099
2146 | PARRA | 2099
2147 | PARRA | 2099
2147 | PARRA | 2100
2147 | PARRA | 2101
2147 | PARRA | 2101
2148 | PARRA | 2101
2148 | PARRA | 2103
2148 | PARRA | 2103
2148 | PARRA | 2106
2148 | PARRA | 2106
2148 | PARRA | 2111
2150 | PARRA | 2111
2150 | PARRA | 2111
2151 | PARRA | 2112
2151 | PARRA | 2112
2152 | PARRA | 2112
2153 | PARRA | 2113
2153 | PARRA | 2114
2153 | PARRA | 2114
2154 | PARRA | 2116
2155 | PARRA | 2116
2155 | PARRA | 2117
2155 | PARRA | 2122
2155 | PARRA | 2125
2156 | PARRA | 2128
2156 | PARRA | 2133
2156 | PARRA | 2133
2157 | NORTHERN | 2133
2157 | PARRA | 2133
2158 | PARRA | 2135
2158 | PARRA | 2135
2158 | PARRA | 2135
2159 | NORTHERN | 2135
2159 | NORTHERN | 2136
2159 | NORTHERN | 2136
2159 | NORTHERN | 2137
2160 | PARRA | 2137
2160 | PARRA | 2137
2160 | PARRA | 2141
2161 | PARRA | 2143
2161 | PARRA | 2143
2161 | PARRA | 2145
2161 | PARRA | 2145
2162 | PARRA | 2145
2162 | PARRA | 2145
2163 | STGEO | 2145
2163 | STGEO | 2145
2163 | PARRA | 2146
2164 | PARRA | 2147
2164 | PARRA | 2147
2164 | PARRA | 2148
2164 | PARRA | 2160
2165 | STGEO | 2150
2165 | STGEO | 2153
2165 | STGEO | 2153
2165 | STGEO | 2153
2166 | STGEO | 2154
2166 | STGEO | 2155
2166 | STGEO | 2155
2166 | STGEO | 2156
2166 | STGEO | 2156
2167 | PARRA | 2156
2168 | PARRA | 2158
2168 | PARRA | 2160
2168 | PARRA | 2160
2168 | PARRA | 2161
2168 | PARRA | 2164
2168 | PARRA | 2164
2168 | PARRA | 2164
2168 | PARRA | 2165
2170 | PARRA | 2168
2170 | PARRA | 2170
2170 | PARRA
2170 | PARRA
2170 | PARRA
2170 | PARRA
2170 | PARRA
2170 | PARRA
2170 | PARRA
2170 | PARRA
2170 | PARRA
2170 | PARRA
2170 | STGEO
2171 | PARRA
2171 | PARRA
2171 | PARRA
2171 | PARRA
2171 | PARRA
2171 | PARRA
2171 | PARRA
2171 | PARRA
2171 | PARRA
2172 | PARRA
2172 | PARRA
2172 | PARRA
2173 | PARRA
2173 | PARRA
2175 | PARRA
2176 | PARRA
2176 | STGEO
2176 | STGEO
2176 | STGEO
2176 | STGEO
2176 | STGEO
2176 | STGEO
2177 | PARRA
2177 | PARRA
2178 | PARRA
2178 | PARRA
2178 | PARRA
2179 | PARRA
2179 | PARRA
2190 | STGEO
2190 | STGEO
2190 | WEST
2191 | STGEO
2192 | STGEO
2193 | WEST
2193 | WEST
2193 | WEST
2194 | STGEO
2195 | STGEO
2195 | STGEO
2196 | STGEO
2196 | STGEO
2197 | PARRA
2198 | STGEO
2199 | PARRA
2199 | PARRA
2200 | STGEO
2200 | STGEO
2200 | STGEO
2200 | STGEO
2200 | STGEO
2200 | STGEO
2203 | WEST
2204 | WEST
2204 | WEST
2204 | WEST
2205 | STGEO
2205 | STGEO
2205 | STGEO
2206 | STGEO
2206 | STGEO
2207 | STGEO
2207 | STGEO
2207 | STGEO
2207 | STGEO
2207 | STGEO
2208 | STGEO
2208 | STGEO
2209 | STGEO
2209 | STGEO
2210 | STGEO
2210 | STGEO
2210 | STGEO
2210 | STGEO
2211 | STGEO
2211 | STGEO
2212 | STGEO
2212 | STGEO
2212 | STGEO
2213 | STGEO
2213 | STGEO
2213 | STGEO
2214 | STGEO
2216 | STGEO
2216 | STGEO
2216 | STGEO
2216 | STGEO
2217 | STGEO
2217 | STGEO
2217 | STGEO
2217 | STGEO
2217 | STGEO
2217 | STGEO
2218 | STGEO
2218 | STGEO
2219 | STGEO
2219 | STGEO
2219 | STGEO
2220 | STGEO
2220 | STGEO
2221 | STGEO
2221 | STGEO
2221 | STGEO
2221 | STGEO
2221 | STGEO
2222 | STGEO
2223 | STGEO