Hello


How can I disable excel when copying from exp. Cell C4 and past special
formulas into C5 that copy the same cell number exp C4 and not C5.

p.s. €“ I am trying to link the same cells from couple of worksheets into 1
column (exp. In column A, I want to link all C4 cells from all worksheets),
but when I try to do that it links like this C4, C5, C6, etc, but I want that
in column A are all cells C4 from the selected worksheets (but without manual
function retyping).


Thank you very much!

Kindly regards,
ekonomija

=INDIRECT("Sheet" & (ROW()+1) & "!C4") entered into A1 of target Sheet1.

Returns value from Sheet2!C4.

When copied down, A2 will be Sheet2!C4 etc.


Gord Dibben MS Excel MVP

On Thu, 10 Jan 2008 14:36:01 -0800, ekonomija
wrote:

Hello


How can I disable excel when copying from exp. Cell C4 and past special
formulas into C5 that copy the same cell number exp C4 and not C5.

p.s. – I am trying to link the same cells from couple of worksheets into 1
column (exp. In column A, I want to link all C4 cells from all worksheets),
but when I try to do that it links like this C4, C5, C6, etc, but I want that
in column A are all cells C4 from the selected worksheets (but without manual
function retyping).


Thank you very much!

Kindly regards,
ekonomija

That should have read "When copied down, A2 will be Sheet3!C4 etc."


Gord

On Thu, 10 Jan 2008 18:20:00 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

=INDIRECT("Sheet" & (ROW()+1) & "!C4") entered into A1 of target Sheet1.

Returns value from Sheet2!C4.

When copied down, A2 will be Sheet2!C4 etc.


Gord Dibben MS Excel MVP

On Thu, 10 Jan 2008 14:36:01 -0800, ekonomija
wrote:

Hello


How can I disable excel when copying from exp. Cell C4 and past special
formulas into C5 that copy the same cell number exp C4 and not C5.

p.s. – I am trying to link the same cells from couple of worksheets into 1
column (exp. In column A, I want to link all C4 cells from all worksheets),
but when I try to do that it links like this C4, C5, C6, etc, but I want that
in column A are all cells C4 from the selected worksheets (but without manual
function retyping).


Thank you very much!

Kindly regards,
ekonomija