Assume you are saving the data in sheet X, on every button click
initiate a macro to copy the data to a dynamically named range which is
the next empty row in sheet X.

Or, if you want it in reverse sequence, have the macro insert a row at
the top of sheet X and then always copy the data to row 1, or insert
and copy at row 2 if you have headers in row 1.

HTH

DOR


--
DOR
------------------------------------------------------------------------
DOR's Profile: http://www.excelforum.com/member.php...o&userid=29088
View this thread: http://www.excelforum.com/showthread...hreadid=490632