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