COPY from SHEET1 to SHEET2 in real time

[deep]

Hey All,

I want to create a macro to copy the last record of sheet1 to LAST record in sheet2

I want it to copy on change() or lostFocus()... in other words, in real time.

Thanks!

deep