Copy Formula Columns
 

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.

Copy Formula Columns
 

Try this instead.

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

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

--

"Lauravila" wrote in message
...
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.

Copy Formula Columns
 

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

Drag/copy across.


Gord Dibben MS Excel MVP

On Fri, 28 Mar 2008 13:57:01 -0700, Lauravila
wrote:

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.