Copy Formula Columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lauravila - 28 Mar 2008 21:57 GMT

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.

Reply to this Message

PCLIVE - 28 Mar 2008 22:10 GMT

Try this instead.

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

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

> If for example I have the following formula:
> =Sheet!$a1
[quoted text clipped - 5 lines]
>
> Any help ? thank you.

Reply to this Message

Gord Dibben - 28 Mar 2008 22:13 GMT

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

Drag/copy across.

Gord Dibben MS Excel MVP

>If for example I have the following formula:
>=Sheet!$a1
[quoted text clipped - 5 lines]
>
>Any help ? thank you.

Reply to this Message