I am completely new to VB so I apologies if this seems like a ridiculous question.

All I am trying to do is select the last used cell in a column and then copy some non-consecutive cells within that same row. The cells I need are from columns A,E,F,M and P. The purpose of this is to transpose on to another worksheet, I have this code and need no assistance with this it is just selecting and copying the non consecutive cells that I am having the issue with.

This is my code which at the moment only finds, selects and copies the last cell in column A.

Range("A6").Select
Cells(Cells.Rows.Count, "A").End(xlUp).Select
Selection.Copy
Sheets("Info Transfer").Select
Range("D4").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=True
Range("D4").Select

I would be really grateful for some help on this.

Thank You

If you find and select the cell in column A that starts the row, you can use ActiveCell.Offset(rows, columns) to transfer the information:
Sheets("Info Transfer").Range("D4") = ActiveCell.Value
Sheets("Info Transfer").Range("D5") = ActiveCell.Offset(0, 4).Value
Etc

Thank you, all of a sudden it is so simple!

You're welcome!