Transposing Links

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to link one file to another and copy the information. One file lists the info in a column, the other in a row, and I want to be able to drag (copy and paste) the linked info across the row (from the column) in my new file. Is this possible

Thanks for your help.
 
I don't think you can do a drag. What you can do is copy
the column and do a paste special->transpose.

-----Original Message-----
I'm trying to link one file to another and copy the
Click to expand...
information. One file lists the info in a column, the
other in a row, and I want to be able to drag (copy and
paste) the linked info across the row (from the column) in
my new file. Is this possible?
 
The idea is for the sheets to update automatically without manually copying and pasting. Is this possible? Thanks
 
Say your first range is 12 rows by 1 column (say A1:A12 on sheet1)

On the second sheet, select a range 12 columns by 1 row (say a1:L1 on sheet2)

type this formula:
=transpose(sheet1!a1:a12)

This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)
 
Back
Top