How can I make cell data automatically shift up when deleting...

[Orangepegs]

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.

 

[Max]

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,ROWS($A$1:A1))),"",INDEX(Sheet1!A:A,MATCH(SMALL
(Sheet1!D,ROWS($A$1:A1)),Sheet1!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