Copy Formula Columns

L

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

PCLIVE

Try this instead.

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

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