Formula for 4 sheets

[noelmus]

Hi,
Is it possible that a formula in a workbook work separately for 4 sheets in the same workbook? All you have to remember is that the answer comes out from the same cell of the formula.

Thanks in advance

 

[Joe4]

I don't think it is quite clear what you want to do. I think we need more details.
Can you be more specific into exactly what you are trying to do?

 

[noelmus]

OK,
Let say have 4 sheets ( from sheet 1 to sheet 4) and in sheet 5 I have a formula which is very complex. So I'm going to give a simple example what I need.
In sheet 5, I have C3=Sheet1!A1 and D3=Sheet1!B1. The addition of C3 and D3 is in cell E3. So in Sheet 1 when I write in A1 and B1, the answer appears in cell E3 of sheet 5. Then I have cell A12 of sheet 1=Sheet5!E3. So the final answer appears in cell A12 of sheet 1.
Now I also need that In sheet 5, I will have C3=Sheet2!A1 and D3=Sheet2!B1. So again the addition of C3 and D3 is in cell E3 and again I need that cell A12 of sheet 2=Sheet5!E3.
So my first problem is that I can't put 2 formulas in one cell. Second problem is that If I update sheet 1, cell A12 of Sheet 4 becomes equal to cell A12 of Sheet 1.
So all I want is that when I populate cells A1 and A2 of sheet 1, answer does not affect cell A12 in Sheet 2.

Thanks

 

[Joe4]

I am very confused as to why you are doing this. What is the end goal, ultimate puprose here?
Why are you trying to use the same ranges in Sheet5 for so many different purposes?
And why not just have cell A12 on Sheets 1-4 pull from from cells A1 and B1 on those same sheets, instead of pulling from Sheet 5?
What is the purpose of going to the cell references on Sheet5, which are just cell references back to the Sheet you are trying trying to update?

 

[noelmus]

No problem, I told you that the formula is a little bit complex and the example I gave was a simple one.
I try another way.

Thanks a lot