Auto moving cells

[Spinal]

We use Excel 2002 XP at work, and im trying to find out if its possible to
get excel to auto move a cell to the next column.

The spread sheet is setout with 5 columns and is about 20 rows down.

Each cell has a number in it (which is the number of each till in the
store). This gets change quite a few times each week and as they are all in
alphabetical order, if a number needs adding or removed, we have to keep
doing it buy insert shit cells down etc, then the problem is since its only
20 rows down 1 cell will move on to row 21.

Would it be possible to make excel auto maticall move this cell to the top
of the next column.

(Or if a number is deleted, row 20 of that column, ends up been empty, can
excel be setup to move the rest of the cells etc.)

 

[Debra Dalgleish]

You could enter the numbers on Sheet1, and use a formula to sort the
numbers on Sheet2. For example, with numbers in Sheet1!A1:E20, enter the
following formula in Sheet2!A1:

=LARGE(Sheet1!$A$1:$E$20,ROW()+20*(COLUMN()-1))

Copy the formula down to row 20, and across to column E