Do hope someone can help me with this. I am not sure whether a function
would do the job, or whether it requires a macro.

I need to be able to have a button set up so that when a row has been
entered it can then be clicked on, and a copy of that row will be put
on another sheet.

The rows on the second sheet should be in sequence order - latest last.
The row on the first sheet would be overwritten each time an entry was
required, and the second sheet would have a summary of all rows
entered.

Hope that's clear, does *Offset* come into the solution somewhere?


--
Jenno
------------------------------------------------------------------------
Jenno's Profile: http://www.excelforum.com/member.php...o&userid=26236
View this thread: http://www.excelforum.com/showthread...hreadid=395283