Finally managed to get this little brain teaser sorted with some help, you needed to insert a code into the macro which was the hard part but then it was sorted at the press of a button
I was doing it manually at first which was taking forever, took me an hour just to do the names beggining with a.
Thanks for all the ideas anyhow, if anyone might for some bizzare reason need the same doing let me know and i`ll send you the sample.
