Firstly, the example workbook can be downloaded, virus free, here: http://www.megaupload.com/?d=CEIAF694

I need a macro that will take the data in the first tab and sort it under the headings in the third (final) tab.

The addresses may be a little confusing to whoever reads this. Basically, the Town, County and Postcode will always be the last three seperated word/s in the address cell; the First Line of Address, will of course be the first word/s.

There is also a heading called VTS Program which will be the first title found above an entry in the first tab; so, for example, there is a heading above several entries in row 3 and another in row 110. Peter Barker would have his VTS labelled as the reference in row 110; Lyndon Wagman would have his VTS labelled as the reference in row 3.

As stated, I will send the person who can create the macro that solves this $5 (or £.3.25) usng PayPal (no other payment method will be considered). It might not be much, be at least it's an incentive.

Merci beaucoup.