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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Paste options button disappears 0
Need Help with a VBA subroutine 0
Copy addition formula of non-consecutive horizontal cells 2
Repeating a row other than the 1st row as the header row in a table from next page 1
How to paste this down? 3
Integrating information from Word to Excel (not mail merge) 1
Copying Rows with values in column A pasting in a new doccument and saving that doc 1
Copying Portions of Data 0

Top