how do I copy and paste links vertically.

shrek

Board Regular
Joined
Dec 16, 2005
Messages
244
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.
 

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

shrek

Board Regular
Joined
Dec 16, 2005
Messages
244
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
 

shrek

Board Regular
Joined
Dec 16, 2005
Messages
244
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
 

Watch MrExcel Video

Forum statistics

Threads
1,113,986
Messages
5,545,347
Members
410,679
Latest member
rolandbianco
Top