LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 331
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need Formula to renumber column crj Excel Discussion (Misc queries) 4 March 26th 10 03:17 AM
renumber automatically JICDB Excel Worksheet Functions 3 May 1st 08 02:14 PM
How do I renumber a worksheet GaryMay Excel Programming 8 March 17th 07 03:52 AM
how do you renumber column in your excel table N Locatis Excel Discussion (Misc queries) 1 March 3rd 06 09:19 PM
Renumber a WorkSheet Mirco Wilhelm Excel Programming 4 January 2nd 06 01:59 PM


All times are GMT +1. The time now is 10:52 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"