hi,
assumption:
1.data will be entered on row2 sheet1
2.Data will be transfers to sheet2
3.the world is not flat

Rows("2:2").Copy Destination:= _
Sheets("Sheet1").Range("A65000").End(xlUp).Offset( 1, 0)

edit to fit your data.

regards
FSt1
"Jenno" wrote:


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