Excel - disable automatic function
 

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

Excel - disable automatic function
 

=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

Excel - disable automatic function
 

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