Excel - disable automatic function

[ekonomija]

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

 

[Niek Otten]

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


| 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
|

 

[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:

 

[Gord Dibben]

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

 

[ekonomija]

Thanks a lot!

It helped!

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


Korisnik "Gord Dibben" napisao je: