M.Gallagher Wrote:
Hi,

....

The problem is that the 'Name' field is in the format of 'RW & T
Cottle' or 'M Granger' (just like in the phone book) so as you can see
I CAN'T sort this column by last name and then make a copy of every
entry that matches the search string.

Michael Gallagher

As I understand your problem the Name column has full name - first
name, middle name and surname ( I really do not know 'RW & Cottle'
format ) so obviously you cannot sort on surname. But is it not Ok to
scan the whole name for a string of character say "Alfred" and then
copy the the row where Alfred occurs in the name? Generally the string
that you will want to search for, will invariably be a part of surname
and not first name. What I mean is if you are looking for Granger you
don't expect Granger to be a first name. It is quite unlikely that name
has Granger but it is not part of surname but first name. If this is
acceptable then it would be very easy to handle this.

A V Veerkar


--
avveerkar
------------------------------------------------------------------------
avveerkar's Profile: http://www.excelforum.com/member.php...o&userid=30338
View this thread: http://www.excelforum.com/showthread...hreadid=509708