auto move cells/data

[Spinal]

Does anyone know if its possible to get excell to automatically shift cells
(and the data in them) if a new cell is added or an older one is deleted.

This is what im trying to do.

I have an excel spread sheet which is 6 colums and 30 rows wide.

Each cell has a number in it going downwards in the list.

Is it if i say delete the cell in say C13, is it possible to get excel to
automatically move the cells up from the other colums, (ie the number that
was in C30 is now in C29 and C30 is empty, so could it automatically move D1
into C30 and move the same for the rest of the rows, (ie move them all up
one cell.)

The same for if i add a cell, (ie in cell C13 C30 would move to C31 but can
i get it to auto move to C32 and the same for the other colums/rows.

Ive tried but cant find if its possible to do this, as it would save a lot
of cut and pasting move all the cells etc.

If any one needs an idea of what im doing i can upload the spreadsheet to my
webspace

 

[Kieran]

Spinal,

I think this is achevable, but I need to know:
how you 'insert' new cells? Do you simply add to the nd of the list,
or do you insert new cells in the middle of the range.

Does the order of the cell entries have any significance, or can they
be returned in a different order to that which they were entered in?

If the order is siginicant, what is the determinant for the cell
order?


Enough questions.

 

[Spinal]

Spinal,

I think this is achevable, but I need to know:
how you 'insert' new cells? Do you simply add to the nd of the list,
or do you insert new cells in the middle of the range.

Does the order of the cell entries have any significance, or can they
be returned in a different order to that which they were entered in?

If the order is siginicant, what is the determinant for the cell
order?


Enough questions.

Hi,

The cells that are inserted can be anywhere, middle, top bottom etc using
the rightclick insert cell , as the list is a list of tills numbers in the
store. (so i has to be updated when tills get removed or new tills get put
out etc).

They run in numerical order but there are gaps between them, (ie it could be
like 1 - 10, 13, 14, 18-22 etc),