Hi Was wondering if sombody could help

I have a excel problem

i need to copy a complete row of data into a new sheet but the code needs to move to the next blank row

I was thinking of using the Selection.End(xlDown).Select command but i have to admin my VB isnt up to scratch to use it

If i had the row of data in Sheet 1 row 2 and i need the whole row pasted in the next available row in sheet 2

is there a simple code to do it

thanks

steve