Here's my response to your almost identical post in .misc
a couple of hours ago (Pl do not multi-post)

One way ..

Assuming this table is in Sheet1, cols A to C,
data from row1 down

A B C
1) Dog Bone Leash
2) Cat Catnip Litter
3) Bird Seed Newspaper
etc

Put in D1: =IF(A1="","",ROW())

Copy D1 across to F1, fill down to say, F1000
to cover the max expected data range in cols A to C

In Sheet2
-------------
Put in say, A2:

=IF(ISERROR(SMALL(Sheet1!D:D,ROWS($A$1:A1))),"",IN DEX(Sheet1!A:A,MATCH(SMALL
(Sheet1!D:D,ROWS($A$1:A1)),Sheet1!D:D,0)))

Copy A2 across to C2, fill down to C1001
(cover same range as in Sheet1)

Sheet2 will auto-return the desired behaviour
depending on changes made in Sheet1

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Orangepegs" wrote in message
...
I need the entire column of names to shift up when I delete one so that
there
are no spaces in the list. Is it possible to do this automatically? I am
creating a spreadsheet for a non-computer literate person, and the less
work
she has to do, the better.