UK Postcode Split

Try:

Please Login or Register  to view this content.

Another option is to use Regex

Please Login or Register  to view this content.

If there is match, the RegExp function will return at least 1 and max 2 non-digits from the beginning of the cell content or else will return vbNullString

You're welcome. Thanks for the rep.

I would suggest that you just loop through the worksheets, count the rows on each one, and then concatenate that with the original sheet name, perhaps separated by a space so that it will be easy to locate and update if required.

Well, you can't do it until the processing is complete otherwise you wouldn't be able to locate the sheet for the post code group. So looping when the process is complete is the only way AFAICS

Originally Posted by TMS

Well, you can't do it until the processing is complete otherwise you wouldn't be able to locate the sheet for the post code group. So looping when the process is complete is the only way AFAICS

Well, one possible approach is to create collection/dictionary with postcode as key (the postcode part) and respective target sheet as object/target sheet name (depending on if you are using collection or dictionary). Then every time you can get the target ws from the collection and you can change the sheet name with every record added to that sheet. not that it will be very useful. better loop at the end :-)