david adams
asked on
How can I copy data from a row that horizontal into a vertical column
I have a row of data and I need to copy and paste link in the same order but in a column.
I.E I have data in row 1 in cells A1-E1but im trying to paste link into a new workbook but paste in column order I.E A1-E1 I need pasting into row C from C1-C5.
Is there any way round it by not copy and pasting each one individually.
I.E I have data in row 1 in cells A1-E1but im trying to paste link into a new workbook but paste in column order I.E A1-E1 I need pasting into row C from C1-C5.
Is there any way round it by not copy and pasting each one individually.
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
aaahhhh never heard of that before. Would it work if copy and pasting on 2 seperate sheets.
Yes, it will work across sheets.
»bp
»bp
Microsoft Excel
Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.
144K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
It could be done through VBA.