How to transpose formulas from column content to row content.

G

Guest

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.
 
G

Gord Dibben

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

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


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using the =page! feature to transpose a row to column 0
using row number or column letters in formula 5
insert blank row and formulas 1
Dependent drop down dynamic range formula, off sheet. 7
Query content of merged cells 3
Transpose Maybe? 7
Transpose row to read to column 7
Incrementing Formula by Column Instead of by Row 1

Top