Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need Formula to renumber column | Excel Discussion (Misc queries) | |||
renumber automatically | Excel Worksheet Functions | |||
How do I renumber a worksheet | Excel Programming | |||
how do you renumber column in your excel table | Excel Discussion (Misc queries) | |||
Renumber a WorkSheet | Excel Programming |