| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy values in columns to rows | Excel Worksheet Functions | |||
| How do i copy rows to columns on separate sheet, and have them upd | Excel Worksheet Functions | |||
| How to copy some text in columns and rest in rows | Excel Discussion (Misc queries) | |||
| copy formulas to cells absolute rows and variable columns | Excel Discussion (Misc queries) | |||
| Macro to copy cells to rows below | Excel Discussion (Misc queries) | |||
Linear Mode
