Hi Max,
Between you and another reply I have got it sorted so to speak. It works
great. Thanks so much
Sue

"Max" wrote:

One play ..

Assume the linked names are in col A, A1 down

Use an adjacent helper col B

Put in B1: =IF(A1=0,REPT("z",10),A1)
Copy B1 down

Now sort both cols A & B using col B
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Sue" wrote in message
...
I have a worksheet which has names paste linked from another workbook.
The
rows all default to "0" til a name is filled in on the other workbook for
that cell. Not all the rows will end up with a name in them so when I go
to
sort the worksheet once all names that are to be entered over time have
been
done I get all the "O" rows at the top and then the names alphabetically
sorted after that. How can I get all the "0" rows to go to the bottom of
the
sorted list.