updated row comes at the top

[Fam via OfficeKB.com]

Is there any way to get the update rows (on the same sheet, which consist of
over one thousand lines of data) at the top? For instant, if I add a comment
on line 561, save & close it and if re-open it, that row 561 pop up at the
top?
Any help will be highly appreciated.
Thanks

 

[Bryan Hessey]

Why not setup a button to insert a new Row 2, and add your data to the
row you need it to be?

Rows cannot appear out of sequence, the 561st row is the 561st row, it
cannot appear first.

--

 

[John James]

Wherever your cursor is on that worksheet when you save the file (say at
the bottom of the data) is where the worksheet opens next time.

If you press Ctrl & End together (and then hold down Ctrl and the
required arrow keys if necessary), you should navigate to the last
entry very quickly