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

--
Message posted via http://www.officekb.com

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.

--

Fam via OfficeKB.com Wrote:
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

--
Message posted via http://www.officekb.com


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=531559

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


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=531559