Scripting Dictionary

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,524
Office Version
  1. 2019
  2. 2016
  3. 2013
Platform
  1. Windows
I know these appear really fast, I have a worksheet that grows every day and currently 98% has to be looked up manually (basically a location, that then develops into postcode ad easting & northing plus A&B identifier's

In the table shown as A I am developing values in Col AN

I want to keep extending the lookups, and using those quickly fill Cols T to AI, overwriting with predefined values from the original work

can someone give me, vba to load T to AI into a dictionary

then a workable code that would look at AN, so the dictionary can be applied to the correct line.

I have 19 years of data over 35,000 lines, each success will reduce further the amount of time required to cross check and populate

Excel Workbook
ABCDEFGHIJ
1Master StreetsReturned Values
2Col ANTUVWYAGAHAI
3PERRY STREET @ THAMES ROADA2000PERRY STREETA206THAMES ROADDA154Hd 118551707176034
4PENTONVILLE ROAD @ ISLINGTON HIGH STREETA501PENTONVILLE ROADA1ISLINGTON HIGH STREETN140Qb 70531452183143
5THAMES ROAD @ PERRY STREETA206THAMES ROADA2000PERRY STREETDA154Hd 118551707176034
6ACANTHUS DRIVE @ACANTHUS DRIVESE150Wb 91534214178356
7ACANTHUS DRIVE @ ROLLS ROADACANTHUS DRIVEB204ROLLS ROADSE150Wb 91534233178325
8ACANTHUS DRIVE @ ACHILLES CLOSEACANTHUS DRIVEACHILLES CLOSESE150Wb 91534303178340
9ROLLS ROAD @ ACANTHUS DRIVEB204ROLLS ROADACANTHUS DRIVESE150Wb 91534233178325
10ACHILLES CLOSE @ ACANTHUS DRIVEACHILLES CLOSEACANTHUS DRIVESE150Wb 91534303178340
Sheet3
 

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Watch MrExcel Video

Forum statistics

Threads
1,129,467
Messages
5,636,456
Members
416,919
Latest member
twc2c

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