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