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.

Hi there!
I don't understand why you write the formula in both A1 and A2 and use both of them to copy.

I wrote the formula:
=[File2_details.xls]Sheet1!A1*[File2_details.xls]Sheet2!A1/[File2_details.xls]Sheet3!A1

and when I copy this down to A2, A3, A4 etc I get the following result:
Cell A2: =[File2_details.xls]Sheet1!A2*[File2_details.xls]Sheet2!A2/[File2_details.xls]Sheet3!A2

Cell A3: =[File2_details.xls]Sheet1!A3*[File2_details.xls]Sheet2!A3/[File2_details.xls]Sheet3!A3

Cell A4: =[File2_details.xls]Sheet1!A4*[File2_details.xls]Sheet2!A4/[File2_details.xls]Sheet3!A4

which all seems to be correct if I didn't misunderstand anything.
Of course you must make sure that the references are relativ in cell A1, meaning they should be A1 and not $A$1.

Kind regards
Bjorn

Hi Bjorn.
Thank you for your reply...I wasn`t carefully enough to see that my references were with $ sign...