That seems to work nicely on the sample sheet :-)

However I can't see what is running it IE how do I get that onto my main spreadsheet.
It isn't a macro & View Code doesn't reveal anything?

Also where you have put the postcodes on sheet 2 I would like to be able to name this clientrequests

Can you advise further. Thanks