Hi Micks,
Not much to go on. If your detail sheet already has names that
don't match the addresses on the same row then they aren't going
to get better.

Some things to think about.
VLOOKUP Worksheet Function if you have good detail data somewhere
that you can match up from your sheets.

Restore from a Backup if you have one of those hanging around.

Filter, may allow use of a master sheet to be used to filter on some element
need to distinguish a customized listing.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"micks" wrote in message
...

cheers for the reply
i'd already tried this
but it doesnt sort my problem
i prob cant do what i want to do
the sheet i do the sorting on is ok but the "details" one has the names
"copied " from sheet i sort, using a formula
but the other columns that containing phone no's etc dont match the
names as the names move with the sort

i'm confusing myself at this stage
cheers



--
micks
------------------------------------------------------------------------
micks's Profile: http://www.excelforum.com/member.php...o&userid=26021
View this thread: http://www.excelforum.com/showthread...hreadid=393747