Hi. I'm using MS Windows XP (Home) and Excel 2003. I have a worksheet with
five columns and about 10,000 rows. I intend to do a lot of sorting on these
columns. However, I want to be absolutely certain that the original order is
always maintained (why I'm not using MS Access is a long story -- suffice it
to say that I need to use Excel). So after I do a sort and perform a few
tasks I want to click on a KeyID column and see the original order that I had
before the sorting. Occasionally I will add a few rows of new material --
say between rows 100 and 120, or between 3330 and 3340. Here are my newbie
questions: First, how do I create a KeyID column (so the rows are numbered
[automatically?] from say 1 to 10,000 or to the last row in the worksheet)?
Second, how to I renumber the column when new rows are entered amid the
original worksheet? To repeat: after sorting I want to return to the
original order, so I have to be very careful not to mess things up. Also,
did I read some where that worksheets have a tendency to become somewhat
unstable after many sorts? Could someone please give me some detailed
information about this? Thanks.