How to transpose formulas from column content to row content.
 

When copying formulas from one sheet to another, then dragging the formulas
to mirror those on the other sheet, it only works with the same format. I
want to drag a formula along rows whilst copying the COLUMN cells on the
other sheet. It simply doesn't work no matter what I try. I don't belive
there is a way to do it.
e.g. A cell on sheet2 contains the formula =sum A1,sheet 1. If I drag that
cell along the row, the formula will continue, =sum A2,sheet1, and so on. I
want it to say, =sum B1,sheet1, etc. That will only work if I drag down a
column.

How to transpose formulas from column content to row content.
 

In A1 of the sheet enter this formula then copy across row 1.

=INDIRECT("Sheet2!A"&COLUMN(A1))


Gord Dibben MS Excel MVP

On Thu, 12 Oct 2006 07:08:02 -0700, Notrom
wrote:

When copying formulas from one sheet to another, then dragging the formulas
to mirror those on the other sheet, it only works with the same format. I
want to drag a formula along rows whilst copying the COLUMN cells on the
other sheet. It simply doesn't work no matter what I try. I don't belive
there is a way to do it.
e.g. A cell on sheet2 contains the formula =sum A1,sheet 1. If I drag that
cell along the row, the formula will continue, =sum A2,sheet1, and so on. I
want it to say, =sum B1,sheet1, etc. That will only work if I drag down a
column.