how do I copy and paste links vertically.

[shrek]

I have a workbook which has data in it horizontally. Im trying to copy and paste link so it pastes it vertically. Can anyone help.

 

[shrek]

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

 

[mrhartley]

Hello,

Will paste special > transpose be any good to you?

Regards
~Mark

 

[shrek]

Tried that but its adding the value of the adjcent cells that are in the workbook that im trying to copy to and not pasting from the workbook