Sort and Renumber
 

I am trying to change a number in a column A then have all the rows
renumbered then sorted in ascending order.

Layout:
- I have column headers in A1-A3 so the cell range A4:I13 contains my data.
- Column A starting at A4 has numbers 1 - 10.

So, when I change number 8 in A11 to 3 the entire row needs to move or
inserted to A6 and all rows from A6 need to moved down one and renumbered so
that the numbers in column A are back 1-10.

If I change number 2 in column A5 to 4 the row moves and rows need to be
moved up and resort so that column A is still 1-10.

Thanks you for you help.

Sort and Renumber
 

Here is a trick. Put in column A the following formula

In cell A4
=row(A4)-3

Then copy this formula down the entire column A.



"Greg" wrote:

I am trying to change a number in a column A then have all the rows
renumbered then sorted in ascending order.

Layout:
- I have column headers in A1-A3 so the cell range A4:I13 contains my data.
- Column A starting at A4 has numbers 1 - 10.

So, when I change number 8 in A11 to 3 the entire row needs to move or
inserted to A6 and all rows from A6 need to moved down one and renumbered so
that the numbers in column A are back 1-10.

If I change number 2 in column A5 to 4 the row moves and rows need to be
moved up and resort so that column A is still 1-10.

Thanks you for you help.