Hello everybody.


I have a question if can somebody help..
I have two excel files.
First has 12 worksheets, and the second just one.
in the second excel file I want to obtain the result of a calculus from the first excel file.
Example: in A1- sheet 1 of excel file nr. 2 I want to obtain the rezult of :
(A1-sheet 1 of excel file nr.1)x(A1-sheet 2 of excel file nr.1)/(A1-sheet 3 of excel file nr.1).


I made this again for A2 cell:

(A2- sheet 1 of excel file nr. 2) = (A2-sheet 1 of excel file nr.1)x(A2-sheet 2 of excel file nr.1)/(A2-sheet 3 of excel file nr.1)


After that I select the A1 and A2 cells from (sheet 1 of excel file nr.2).
Now I want copy the mentioned formula for A3, A4, A5 and so on, but it doesn`t work. It is not possible to made a link like that in excel, or I made something wrong?

I must mention that is necessary to work with two excel files. I know that with the 13rd worksheet in the first excel file it works.

Thank you in advance.