$5 (£3.25) if you can create the macro that solves this problem!

**Captain Useless** · 02-20-2010, 02:13 PM

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.

**JBeaucaire** · 02-20-2010, 03:14 PM

You should provide a couple more examples. How does this address breakup into your table:

Torrington Park Group Practice [ ]16 Torrington Park[ ] North Finchley[ ] London[ ] N12 9SS
South View Lodge[ ] South View [ ]Bromley[ ] Kent[ ] BR1 3DR

Line 161 and 362 are missing a space...probably a critical error for a project like this.
Line 229 ans 230 have extra lines, probably a critical error for a project like this.

**teylyn** · 02-20-2010, 06:36 PM

Hello Capatain Useless,

welcome to the forum.

However, your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Also, if you wish to engage a consultant for paid work, please post in the Commercial Services Exchange forum.

**martindwilson** · 02-20-2010, 07:57 PM

wow thats a couple of miles from me
South View Lodge[ ] South View [ ]Bromley[ ] Kent[ ] BR1 3DR
i'll pop round and ask them to upload their data in a more usable format lol