Copy cells to last empty row of column in another sheet.

Hi

I need help to copy and paste as values only the following:

Sheet1 N1:O1 to last empty row of Sheet2 column AB. Note that table starts on AB6.
Sheet3 C4 --> Sheet2 AD
Sheet4 B3 --> Sheet2 AE
Sheet2 D31 --> Sheet2 AF
Sheet2 D35 --> Sheet2 AG
Sheet2 D2 --> Sheet2 AH

Thanks a lot!

Originally Posted by alansidman

What row do you wish these pasted to?

Sorry, I also meant, to the last empty row for these as well as the above code indicates.

Now, however, I need to solve this trivia:

If the target range has a border as indicated in the picture, how do I paste said data so that the pasted data gets included in the border?
Note that inserting a row is NOT an option as that would disrupt adjacent data.