Newbie: Help with OFFSET function
 

On Sheet1 I and Row106 I have 50+ columns of calculation results that I want
copied to Sheet2, Column 4 over the equivalent number of rows.

=OFFSET('Recipe Calculation'!$D$106,COLUMN()-4,0)

....the result of Sheet1, Row106 and Column4 is dead on, but when I want to
copy the above function to the other cells of Column4 on Sheet2, the result
is always the same as on the first cell. What am I doing wrong?

I can't get my head around this and the Excel Help file is not much better
than the Excel book I have. Please help.

Thanks in advance...Carlos

Try this instead:

=INDEX('Recipe Calculation'!$106:$106,ROW(4:4))

And copy down as needed.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"CF" wrote in message
.. .
On Sheet1 I and Row106 I have 50+ columns of calculation results that I
want
copied to Sheet2, Column 4 over the equivalent number of rows.

=OFFSET('Recipe Calculation'!$D$106,COLUMN()-4,0)

...the result of Sheet1, Row106 and Column4 is dead on, but when I want to
copy the above function to the other cells of Column4 on Sheet2, the
result
is always the same as on the first cell. What am I doing wrong?

I can't get my head around this and the Excel Help file is not much better
than the Excel book I have. Please help.

Thanks in advance...Carlos

Thanks RD, that worked...Carlos


"Ragdyer" wrote in message
...
Try this instead:

=INDEX('Recipe Calculation'!$106:$106,ROW(4:4))

And copy down as needed.
--
HTH,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"CF" wrote in message
.. .
On Sheet1 I and Row106 I have 50+ columns of calculation results that I
want
copied to Sheet2, Column 4 over the equivalent number of rows.

=OFFSET('Recipe Calculation'!$D$106,COLUMN()-4,0)

...the result of Sheet1, Row106 and Column4 is dead on, but when I want
to
copy the above function to the other cells of Column4 on Sheet2, the
result
is always the same as on the first cell. What am I doing wrong?

I can't get my head around this and the Excel Help file is not much
better
than the Excel book I have. Please help.

Thanks in advance...Carlos

Appreciate the feed-back.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"CF" wrote in message
.. .
Thanks RD, that worked...Carlos


"Ragdyer" wrote in message
...
Try this instead:

=INDEX('Recipe Calculation'!$106:$106,ROW(4:4))

And copy down as needed.
--
HTH,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-
"CF" wrote in message
.. .
On Sheet1 I and Row106 I have 50+ columns of calculation results that I
want
copied to Sheet2, Column 4 over the equivalent number of rows.

=OFFSET('Recipe Calculation'!$D$106,COLUMN()-4,0)

...the result of Sheet1, Row106 and Column4 is dead on, but when I want
to
copy the above function to the other cells of Column4 on Sheet2, the
result
is always the same as on the first cell. What am I doing wrong?

I can't get my head around this and the Excel Help file is not much
better
than the Excel book I have. Please help.

Thanks in advance...Carlos