Copying a row onto the next available row in another sheet....

[shona_jk]

Hi, Can someone help please. I want vb (2010) code to copy a row from one sheet to another sheet onto the next available row under/starting from cell A7. This is the code I have so far but the rows are being pasted all over the place.

Sheets("Raw Data").Select
Range("A5:BM5").Select
Selection.Copy
Sheets("Statistics").Select
FinalRow = Range("A65536").End(xlUp).Row
ActiveSheet.Paste

Help would be appreciated.

[JOHN H. DAVIS]

If A7 has data this may work for you.

Please Login or Register  to view this content.

[shona_jk]

Hi John,

Thank you! This is starting it from Column A but I don't have any data in column A1, 2, 3, 4, 5, 6 and 7. There is data in B4, 5, 6 etc though.

[JOHN H. DAVIS]

Try this:

Please Login or Register  to view this content.