Copy Formula Columns

[Lauravila]

If for example I have the following formula:
=Sheet!$a1

and I want to copy it in the colums. I would like to have:
=Sheet!$a1 =Sheet!$a2 =Sheet!$a3... etc.

but by just dragging the cell I always get the same =Sheet!$a1

Any help ? thank you.

 

[PCLIVE]

Try this instead.

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

Note, this will only work when copying across (not down).
HTH,
Paul

 

[Gord Dibben]

=OFFSET(Sheet1!$A$1,COLUMN(A1)-1,)

Drag/copy across.


Gord Dibben MS Excel MVP