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.