Apologies I didnt make it clear. The workbook im trying to copy and paste from has another workbook linked to it via copy and paste special.
Im trying to copy the cells from the workbook that has the link to it already so it pastes it on another worksheet but posts the values vertically. If I cannot do that via copy and paste special I can do a macro so it copy and pastes at the end.
Can anyone help as to how I can copy cells from a spreadsheet that has data input horizontally but be able to paste the data vertically on another worksheet