Auto moving cells

  • Thread starter Thread starter Spinal
  • Start date Start date
S

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.)
 
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
 
Back
Top