finding postcodes

Hi SwanyP,

This kind of problem is a killer as it seems too big.
Find the attached where I've helped a little.

I searched the net and found a website that is a directory to UK schools. I typed in a school name and looked at the URL for the search. Then I studied the URL and how it searched using the school name. It really just replaced spaces with "+".

You have the school names and Excel can replace space with "+" and can also follow URLs.

I created a little Macro called "Find That School" that put the URL search string in D1 and then opened the web site so you could look. Then you will need to click on the "Info" link, copy the ZIP into the clipboard and come back to Excel to Paste it in, where you like.

I've triggered this macro by double clicking on Column E to the right of the name.

I believe you can shorten your list so it has no duplicates and this might trim your list down to 5,000 schools or less.

This doesn't make your job easy but easier.

hope this helps.