I have (with the help of some of the very talented Excel MVPs) nearly
finished a to do list spread sheet!

http://www.box.net/shared/ejzn141dux

The worksheet works like this:
Enter desired text in cell c3 and then use the drop down button in b3 to
determine the position where the text is to be placed in the below list. If
there is text already in that position all the text below is moved down one
cell. This part of it works fine.

Three lists can be managed this way €“ Home, Work and Other.

However, I would like to be able to delete the text from a cell by using the
backspace button. For example if I deleted the text in C9 (Go Shopping) all
the text in the cells below would be moved up one €“ie, Hoover Lounge would
move up to C9 and Pay Milkman to C10 etc. I would like to be able to do this
for all three lists €“ (which have 100 positions each as the range), but am
not sure how to adapt/add to the already existing VBA code. I have tried, but
am out of my depth.

Yours sincerely,

Matt €“ a hopefully organised infant school teacher in 2010!