copying and pasting rows

J

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
 
D

Don Guillett

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