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

Your question is not entirely clear to me, but consider this:

Use $C$4 instead of C4 in your formula. This is easiest accomplished by putting the cursor in the formula bar on the address and
then press F4.

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


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

Hay,

Thank you very much for your answer but it did not help.

I will give the example:

There are couple of worksheets in my document, that are set up equally for
the each cell (exp. all C3 cells have the same info (client name), H50 =
product price value, etc.)

For all this I have made TOTAL worksheet that adds, divides and make some
calculations with all worksheets in the document.

Those information are set up in the columns like this (for exp):

column A
cell A1: COSTUMER NAME
cell A2: Name 1 (linked from the worksheet with function ='Name 1'!C3
cell A3: Name 2 (linked from the worksheet ='Name 2'! ... well here is the
problem - when I want to copy and past special formula it will give me C4
instead C3

So, I want that all cells in the given TOTAL column exp column A ink the
same cell number, and not C4, C5, C6,... when copy and past.

Is this possible, or I should do that anyway manually :(

Thank you very much!

Kindly,
Irena



Korisnik "ekonomija" napisao je:

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

To keep the cell ref C4 constant and increase the Name 1 ro Name 2 use the
INDIRECT formula I provided.

Change to =INDIRECT("'Name " & (ROW()-1) & "'!C4" and enter in A2 of TOTALS
sheet.

Copy down to A3

BTW...........what means "exp".......example?


Gord

On Thu, 10 Jan 2008 23:26:06 -0800, ekonomija
wrote:

Hay,

Thank you very much for your answer but it did not help.

I will give the example:

There are couple of worksheets in my document, that are set up equally for
the each cell (exp. all C3 cells have the same info (client name), H50 =
product price value, etc.)

For all this I have made TOTAL worksheet that adds, divides and make some
calculations with all worksheets in the document.

Those information are set up in the columns like this (for exp):

column A
cell A1: COSTUMER NAME
cell A2: Name 1 (linked from the worksheet with function ='Name 1'!C3
cell A3: Name 2 (linked from the worksheet ='Name 2'! ... well here is the
problem - when I want to copy and past special formula it will give me C4
instead C3

So, I want that all cells in the given TOTAL column exp column A ink the
same cell number, and not C4, C5, C6,... when copy and past.

Is this possible, or I should do that anyway manually :(

Thank you very much!

Kindly,
Irena



Korisnik "ekonomija" napisao je:

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

Thanks a lot!

It helped!

p.s. yes, exp. = shorter for example :)


Korisnik "Gord Dibben" napisao je:

To keep the cell ref C4 constant and increase the Name 1 ro Name 2 use the
INDIRECT formula I provided.

Change to =INDIRECT("'Name " & (ROW()-1) & "'!C4" and enter in A2 of TOTALS
sheet.

Copy down to A3

BTW...........what means "exp".......example?


Gord

On Thu, 10 Jan 2008 23:26:06 -0800, ekonomija
wrote:

Hay,

Thank you very much for your answer but it did not help.

I will give the example:

There are couple of worksheets in my document, that are set up equally for
the each cell (exp. all C3 cells have the same info (client name), H50 =
product price value, etc.)

For all this I have made TOTAL worksheet that adds, divides and make some
calculations with all worksheets in the document.

Those information are set up in the columns like this (for exp):

column A
cell A1: COSTUMER NAME
cell A2: Name 1 (linked from the worksheet with function ='Name 1'!C3
cell A3: Name 2 (linked from the worksheet ='Name 2'! ... well here is the
problem - when I want to copy and past special formula it will give me C4
instead C3

So, I want that all cells in the given TOTAL column exp column A ink the
same cell number, and not C4, C5, C6,... when copy and past.

Is this possible, or I should do that anyway manually :(

Thank you very much!

Kindly,
Irena



Korisnik "ekonomija" napisao je:

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