copying and pasting rows

[josh ashcraft]

hey guys,
I need some help,
I need to copy a row, and paste it into the next available
empty row on a separate sheet, any help would be much
appreciated!!!

thanks,
Josh Ashcraft

 

[Ron de Bruin]

Maybe this will help you Josh
http://www.rondebruin.nl/copy1.htm

 

[Don Guillett]

Sub copyrowtoothersheet()
ActiveCell.EntireRow.Copy
Sheets("sheet10").Range("a65536").End(xlUp).Offset(1)
End Sub