copy cells from columns to rows
 

I have to copy multiple cells from a column in one sheet in a workbook to
another sheet. For example in "row 1 column a" I have : +Detail!B$31; row 1
column b: +Detail!B$110. How do I copy this to row 2 column a to be
:+Detail!c$31; row 2 column b: +Detail!c$110
--
Libby

copy cells from columns to rows
 

hi.
copy you data then click where you want to paste it.
on the xl menu bar....
EditPasteSpecialcheck transposeclick ok

regards
FSt1


"Libby" wrote:

I have to copy multiple cells from a column in one sheet in a workbook to
another sheet. For example in "row 1 column a" I have : +Detail!B$31; row 1
column b: +Detail!B$110. How do I copy this to row 2 column a to be
:+Detail!c$31; row 2 column b: +Detail!c$110
--
Libby

copy cells from columns to rows
 

That doesn't work. I had already tried that.
--
Libby


"FSt1" wrote:

hi.
copy you data then click where you want to paste it.
on the xl menu bar....
EditPasteSpecialcheck transposeclick ok

regards
FSt1


"Libby" wrote:

I have to copy multiple cells from a column in one sheet in a workbook to
another sheet. For example in "row 1 column a" I have : +Detail!B$31; row 1
column b: +Detail!B$110. How do I copy this to row 2 column a to be
:+Detail!c$31; row 2 column b: +Detail!c$110
--
Libby

copy cells from columns to rows
 

Insert in A1 and copy down

=OFFSET(Detail!$B$31,0,ROW(1:1)-1)


"Libby" skrev:

I have to copy multiple cells from a column in one sheet in a workbook to
another sheet. For example in "row 1 column a" I have : +Detail!B$31; row 1
column b: +Detail!B$110. How do I copy this to row 2 column a to be
:+Detail!c$31; row 2 column b: +Detail!c$110
--
Libby

copy cells from columns to rows
 

Libby,
with a bit of a step in between you can get this sorted.
First, highligt all cells that you want copied and use the "Replace"
functionality to change the "=" in the formula's to "qqq"
Then, copy the cells and using paste special transpose post them somewhere
as a column.
Select the pasted cells, and again using transpose change the "qqq" back to
"="
Now copy one column to the right - which gets you your references as desired.

To get it back into shape, go the other way around. Again, change = to qqq,
copy + transpose paste, change qqq to =

Bit of a roundabout way, but it works....

Good luck.



"Libby" wrote:

I have to copy multiple cells from a column in one sheet in a workbook to
another sheet. For example in "row 1 column a" I have : +Detail!B$31; row 1
column b: +Detail!B$110. How do I copy this to row 2 column a to be
:+Detail!c$31; row 2 column b: +Detail!c$110
--
Libby