Reply to Message

Access Has Record #'s - so can Excel
Databases assign record numbers to each record, easily used for links and referencing, and for simplying scrolling to a designated record.

It is easy to create the same feature in Excell - If your 'data' is entered one 'record' per row (like every purchased mailing list I have ever seen) simply add a new column, and number the data rows 1,2,3, etc. I usually do this in Col A, Name the column 'Index', then hide the column.

I cannot tell you how often I have fixed scrambled worksheets by simply sorting on that hidden index column.
Posted by blogs@...
27th Jun 2011