change vba from EntireRow to Column.Range

Hi all,

I'm a bit stuck with this piece of code i found on the net:

Please Login or Register  to view this content.

The problem is, that in the final step, it pasts the entire row from Sheet2 onto the bottom of sheet "original". I would like to only past the cells from column range A to N to be pasted (in case there already would be data in the cells of column O or P they would not be overwritten by pasting the full row).

Is there somebody who can help me out with this issue?

Thanks in advance!

First of all, thanks for trying to help me. I tried out changing it as you did, but the result however stays the same..

Hey hey i found it!

this works:

Please Login or Register  to view this content.

I only left out the "EntireRow" part. Just lucky me, all credits
go to you RoyUK.

Thanks again for your effords !