Hi Michael,
Do you need to copy and paste all the data each time, or just the newly
created row?
If you want all the data each time, do you want to overwrite the copy/paste
from last time, or paste it into a new place?
How big is your data range in Sheet1? Is it in Columns A, B and C?
Do you want the copy/paste procedure to be automatic, or do you want to
activate it with a button or keyboard shortcut?
Do you like vegemite?

Regards - Dave.

"Michael" wrote:

I have three columns in sheet1 that need to copied into sheet2 when a new row
is created in sheet1.