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.