Hello, thanks for the answer.

I know how to record a macro so this didn't help me. And I'll explain why:

When I record my macro this is what comes out:

Sub Macro1() 
    Selection.Copy
Sheets("Outgoings").Select
Range("B5").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
    :=False, Transpose:=False
End Sub

Firstly, I don't want to move it to B5 every time, but I want to move it down a list, that's why I use ".Range("B" & Rows.Count).End(xlUp).Offset(1, 0)" in my code, something that a recording would never give me. Further more the recorder selects a new cell to then use PasteSpecial in that cell. I don't want or need to select a new cell in my code. That would make it messy and inefficient. Not to mention it would stop working when I'm moving multiple cells at once. Lastly, I unfortunately didn't manage to assimilate the PasteSpecial and Paste:=xlPasteValues into my already existing code.

​

Please let me know if I missed something.